Log in

View Full Version : Excel Format


tartack
Mar 8, 2006, 10:01 AM
I need someone help.
Everyday I need to format data like the following
1003, 1876, 1952, 2011, 2048, 2057, 2073, 2094, 2111, 2128
This gets pasted into one cell in a spreadsheet.
I would like to be able to format it so it goes into the sheet
1003
1876
1952 etc into separate cells.

Is this possible ?

Thanks everyone !

RickJ
Mar 8, 2006, 10:08 AM
Is it that the info that you're copying from is always in one row separated by commas?

In other words... is it not possible to copy from word or notepad with the info like this:

1234
4567
7890
etc.

tartack
Mar 8, 2006, 11:32 AM
Yes always in one row separated by commas...

StuMegu
Mar 8, 2006, 11:41 AM
Check out the Text to Columns feature in Excel under the "Data" menu. This will allow you to separate the entries by the comma into different cells.

Once you have done this you can transpose the row into a column - copy the cells you want in the row, select the top of the column where you want them, click "Edit" -> "Paste Special" and select "transpose" - this will magically change the values from going across the sheet to down and vice-versa!

tartack
Mar 8, 2006, 12:11 PM
Nice, just tried that, that worked wonderfully... thank you!! :)

tartack
Mar 8, 2006, 12:13 PM
Humm, I just niticed it keeps the comma... use find and replace I guess to get rid of that ?

ScottGem
Mar 8, 2006, 01:10 PM
I just tested this out and not only did it separate out the numbers into columns (no need for the Transpose) but it got rid of the commas. Make sure you select comma as the delimiter in the dialog.

tartack
Mar 8, 2006, 02:10 PM
Yes it worked, but I still need to transpose as I was each number in a different row, not column.

Thank you Everybody !