Text into column data
 

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

Text into column data
 

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

Text into column data
 

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

"RestlessAde" wrote:

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