Formula required to split uneven data into different columns

[RAM72]

Hi All

I have a database to split data into three different columns in the second column B I managed with a formula, but stuck in column C and D because as data are not uniform.

Annexed sample

Thanks

RAM72

 

[Somendra Misra]

Hi Ram,

One way, See the sample sheet in the file with formulas. Apply on your original file and see if you are getting results. I had created a named range for origin places. Create a similar list and use that in formula.

Regards,

 

[RAM72]

Hi Somendra
I tried as you ask but did some did not give me the expected results for certain items . see attached file

Those highlighted in blue must be in that format.
Is it possible.

Thanks
RAM72

 

[Somendra Misra]

Hi Somendra
I tried as you ask but did some did not give me the expected results for certain items . see attached file

Those highlighted in blue must be in that format.
Is it possible.

Thanks
RAM72

Why row no. 3 & 8 not included in your sample? Are they OK?

Regards,

 

[RAM72]

Yes it includes row 3 and 8 which i omit, this is a sample they must be in blue , the data consists of 500 lines minimum.