Text into column data

[RestlessAde]

Hi,

I have data that is pasted into a single cell as follows:

Canada 4.1 98.6 102.5 105.2 104.6 105.6 106.0 105.3 105.7 106.5 105.3 105.4
105.2 104.8

I would like to create a series of formula in different adjacent cells so
that it will pull the data into different columns. E.g.

Canada would be grabbed from for Col 1
4.1 would be grabbed for Col 2
98.6 for Col3... etc.

I have numerous lines of text like this to enter and it would save lots of
time.

Thanks in advance for any advice.
RA

 

[Ardus Petus]

Try Data>Text to Columns>Delimited

That should fit your needs.

Cheers,

 

[RestlessAde]

I've managed to solve my own problem! Sorry, I'll use search function more
thoroughly before posting next time.

I used the text to column function in the Data menu.

RA