Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Numbers in a cell
I have a worksheet that has multiple numbers (1234, 3425, 34234,etc.) in a
single cell. I need to separate these and create a new row for each one (ie. A1 1234, A2 3425, A3 34234, etc.). Currently I'm having to insert columns, convert text to columns, transpose the data, then copy and paste the rest of the data from the other columns...Is there an easier way? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Numbers in a cell
This might be a quicker work around for you. Highlight and copy all the info
on your sheet. Open a blank "Notepad" and paste everything in there. While it's in raw form in Notepad, put the cursor at the end of each entry and hit the Enter/Return key. Do that until each of your entries is on it's own line on the Notepad document like so: 1234 3425 34234 Now copy your numbers from Notepad and past into your Excel sheet, and your entries should each be in their own row. "Booj" wrote: I have a worksheet that has multiple numbers (1234, 3425, 34234,etc.) in a single cell. I need to separate these and create a new row for each one (ie. A1 1234, A2 3425, A3 34234, etc.). Currently I'm having to insert columns, convert text to columns, transpose the data, then copy and paste the rest of the data from the other columns...Is there an easier way? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Numbers in a cell
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "Booj" wrote in message ... I have a worksheet that has multiple numbers (1234, 3425, 34234,etc.) in a single cell. I need to separate these and create a new row for each one (ie. A1 1234, A2 3425, A3 34234, etc.). Currently I'm having to insert columns, convert text to columns, transpose the data, then copy and paste the rest of the data from the other columns...Is there an easier way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to separate multiple numbers in one cell | Excel Worksheet Functions | |||
add multiple numbers in one cell with those numbers remaining visi | Excel Worksheet Functions | |||
Selecting specific numbers from a cell containing multiple numbers | Excel Worksheet Functions | |||
can a single cell contain multiple numbers? | Excel Worksheet Functions | |||
Can you add multiple numbers in the same cell%3f | Excel Worksheet Functions |