Text to columns

[Premmadaan]

Hi all,
PLease hep me out on Attached file where i m not able to split data in seperate seperate coloumn
Thanks

[arthurbr]

Depending on what you need try
Ctrl+H
replace what Delhi
with %delhi
Then apply text to colums delimited using % as a delimiter
After that you can split columns again with fixed width or whatever

[RobertMika]

Your data are not vey consistent so maybe is worth to do this way:

1.Make abraviation to long destination name and replace with short names.
2.Convert text to column



Please see attached

[Premmadaan]

Yes gud idea but this cannot accurate 100 % because data is not proper. but this is heplfull idea..
Thanks to both of you