Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
separating numbers in excel?
Name: roryb Date: March 4, 2009 at 03:00:11 Pacific OS: Windows XP Subcategory: Microsoft Office
Comment:
Hi, 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?
Name: Bryco Date: March 4, 2009 at 05:31:42 Pacific
Reply:
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.
Bryan
0
Response Number 2
Name: roryb Date: March 4, 2009 at 05:52:04 Pacific
Reply:
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.
0
Response Number 3
Name: DerbyDad03 Date: March 4, 2009 at 09:50:19 Pacific
Reply:
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.
Summary: I have a column of numbers in excel 2003, but it won't recognize them as such--the report in excel was generated from another app. Is there any way to tell excel to recognize the numbers as numbers so...
Summary: Hi, I was wondering if there was a way to automatically increase a number in a certain cell every time a file was opened. (Think of an invoice that needs to be incremented every time) If this isn't po...
Summary: This is all I could find in Excel help. Hope it is of some use. M Create a custom number format Select the cells you want to format. On the Format menu, click Cells, and then click the Number tab. ...
0 
how to make a text file
