Try DataText to ColumnsDelimited

That should fit your needs.

Cheers,
--
AP

"RestlessAde" a écrit dans le
message de news: ...
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