Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
text files open with all data in first column | Excel Discussion (Misc queries) | |||
How to convert columns of data to one column of text | Excel Worksheet Functions |