separating numbers in excel?

March 4, 2009 at 03:00:11
Specs: Windows XP
How can I get a list of numbers that are
seperated by spaces in one cell into
seperate cells for each number in ms excel?

This is an example of the list of numbers
in one cell below?

1 28522.4 3407620.6 86.18 4

Any ideas?

See More: separating numbers in excel?

Report •

March 4, 2009 at 05:31:42
In Excel 2007 go to Data, Text to Columns
Select Delimited, Next, choose Space and finish.

It is similar in other versions so look for "Text to columns" or use Help to locate it.


Report •

March 4, 2009 at 05:52:04
Thanks a million.

Do you know how to select multiple cells that are not beside each other but are seperated by the same number of rows each.
I've been trying using 'shift+f8' and selecting them manually but it doesnt seem to work when I scroll down or use 'page down'?
Thanks again for your help.

Report •

March 4, 2009 at 09:50:19
Text To Columns only works on a single cell, or a range of cells in a single column, at a time.

It also needs room to the right to write the separated data. If there is data to the right of the cells, it will ask you if you want to replace the data in the destination cells.

Report •

Related Solutions

Ask Question