How can i get actual data in maltipul data

[Rahul Mishra]

sir i attached excel sheet plz help me in this matter

 

[Khalid NGO]

Hi Rahul,

I have found something relates to your requirement (not completely)
http://www.mrexcel.com/forum/excel-questions/443983-extract-only-numbers-text-string.html

see the file also...

 

[Rahul Mishra]

sir its present error when i drag formula from single cell

 

[prasaddn]

Hi Can you share some more details.

The formula cannot insert additional row to show you the numbers when more than 1 set of numbers are present in input. We can try to get all the sets of numbers from input in the subsequent columns.

Again as we do not know how many sets of expected output will be there in the input, we may have to drag formula manually to subsequent columns.

Are you okay with the above ?

Regards,
Prasad DN

 

[Rahul Mishra]

sir which i attached excel file in this i mentioned format which required