Separate text and numbers in excel of variable length

**anuj.lakhanpal** · 09-03-2008, 06:17 AM

i have this long data set with all the values in one column and also in some cases the last value is missing

Data
Flag Year Built Deadweight Tons TEUs Speed Reefer TEUs
Panama 1991 40499 3054 21 300
Liberia 2005 42200 3100 22

Example last enrt is mssing in the following and speed could be in 1 decimal at times
Flag Year Built Deadweight Tons TEUs Speed Reefer TEUs
Liberia 2005 42200 3100 22.5

Can anyine help in separarting out this long set of data in to individual columns

Thanks

**dominicb** · 09-03-2008, 06:26 AM

Good morning anuj.lakhanpal

...and welcome to the forum!!

Originally Posted by anuj.lakhanpal

Can anyine help in separarting out this long set of data in to individual columns

Try using text to columns.
Highlight your data and go to Data > Text to columns.
Select delimited and click on Next.
As your delimiter choose space and then click on next, then finish.

HTH

DominicB