Ask Experts Questions for FREE Help !
Ask
    tartack's Avatar
    tartack Posts: 17, Reputation: 1
    New Member
    		  
    #1

    Mar 8, 2006, 10:01 AM
    Excel Format
    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's Avatar
    RickJ Posts: 7,762, Reputation: 864
    Uber Member
    		  
    #2

    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's Avatar
    tartack Posts: 17, Reputation: 1
    New Member
    		  
    #3

    Mar 8, 2006, 11:32 AM
    Yes always in one row separated by commas...
    StuMegu's Avatar
    StuMegu Posts: 576, Reputation: 64
    Senior Member
    		  
    #4

    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's Avatar
    tartack Posts: 17, Reputation: 1
    New Member
    		  
    #5

    Mar 8, 2006, 12:11 PM
    Nice, just tried that, that worked wonderfully... thank you!! :)
    tartack's Avatar
    tartack Posts: 17, Reputation: 1
    New Member
    		  
    #6

    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's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #7

    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's Avatar
    tartack Posts: 17, Reputation: 1
    New Member
    		  
    #8

    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 !
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

.avi format player [ 4 Answers ]

Please suggest me a free multimedia player which can play .avi format files on windows98 os.

Format? [ 1 Answers ]

Is there a way in MS Word to merge several different articles & have them all the same length? Instead of: This is just an example! This is just an example!

Format And Reinstall Xp [ 4 Answers ]

I reinstalled xp because of a virse I got rid of but didn't know how to format my drive some things don't work right but it works slow now how do I format c drive and reinstall xp Thanka Tom

Format [ 6 Answers ]

Please give me advise, how can I format hardisk. Is there a website offering a free tool for formatting disk. Thank you!

Format difference [ 3 Answers ]

What is the difference between a FAT32 and a NTFS hard drive? Advantages and disadvantages if any. I have 2 external hard drives - on each Thanks - George :confused:

View more questions Search