Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I re arrange numbers
I copied and pasted a table of numbers from another file (converted a pdf to
excel) that looks like this. (only 4 rows shown here) 102050903818W400 1 6 7.60 334.10 38.86 214.26 211.82 28.29 -14.05 32.66 0.18 102050903818W400 1 7 7.60 338.90 38.98 253.24 250.46 33.01 -16.11 37.81 0.49 102050903818W400 1 8 7.40 335.30 38.86 292.10 288.99 37.69 -18.08 42.89 0.39 102050903818W400 1 9 7.40 336.10 38.84 330.94 327.51 42.24 -20.14 47.88 0.08 All these numbers are in the first column, and with spaces (more than one) between them. I would like to separate them into different columns with a simple equation or function. IS THIS POSSIBLE?? please help. I want these numbers to be like this (Now they are all in A4 to A 160) H4 I4 J4 K4 L4 M4 N4 O4 P4 102050903818W400 1 6 7.60 334.10 38.86 214.26 211.82 28.29 Q4 R4 S4 14.05 32.66 0.18 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I re arrange numbers
Use Data | Text-to-columns and specify <space as the delimiter. Just
work through the Wizard. Hope this helps. Pete On Nov 12, 5:20*pm, Raz wrote: I copied and pasted a table of numbers from another file (converted a pdf to excel) that looks like this. (only 4 rows shown here) 102050903818W400 * 1 * *6 * 7.60 334.10 *38.86 * 214.26 * 211.82 * *28.29 * * -14.05 * * 32.66 * *0.18 102050903818W400 * 1 * *7 * 7.60 338.90 *38.98 * 253.24 * 250.46 * *33.01 * * -16.11 * * 37.81 * *0.49 102050903818W400 * 1 * *8 * 7.40 335.30 *38.86 * 292.10 * 288.99 * *37.69 * * -18.08 * * 42.89 * *0.39 102050903818W400 * 1 * *9 * 7.40 336.10 *38.84 * 330.94 * 327.51 * *42.24 * * -20.14 * * 47.88 * *0.08 All these numbers are in the first column, and with spaces (more than one) between them. I would like to separate them into different columns with a simple equation or function. IS THIS POSSIBLE?? please help. I want these numbers to be like this (Now they are all in A4 to A 160) H4 * * * * * * * * * * * * * * I4 *J4 * K4 * L4 * * * * *M4 * * * N4 * * * * O4 * * * * P4 102050903818W400 * 1 * *6 * 7.60 334.10 *38.86 * 214.26 * 211.82 * *28.29 Q4 * * * * *R4 * * * S4 14.05 * * 32.66 * *0.18 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I re arrange numbers
thanks, exactly what i was looking for,
"Pete_UK" wrote: Use Data | Text-to-columns and specify <space as the delimiter. Just work through the Wizard. Hope this helps. Pete On Nov 12, 5:20 pm, Raz wrote: I copied and pasted a table of numbers from another file (converted a pdf to excel) that looks like this. (only 4 rows shown here) 102050903818W400 1 6 7.60 334.10 38.86 214.26 211.82 28.29 -14.05 32.66 0.18 102050903818W400 1 7 7.60 338.90 38.98 253.24 250.46 33.01 -16.11 37.81 0.49 102050903818W400 1 8 7.40 335.30 38.86 292.10 288.99 37.69 -18.08 42.89 0.39 102050903818W400 1 9 7.40 336.10 38.84 330.94 327.51 42.24 -20.14 47.88 0.08 All these numbers are in the first column, and with spaces (more than one) between them. I would like to separate them into different columns with a simple equation or function. IS THIS POSSIBLE?? please help. I want these numbers to be like this (Now they are all in A4 to A 160) H4 I4 J4 K4 L4 M4 N4 O4 P4 102050903818W400 1 6 7.60 334.10 38.86 214.26 211.82 28.29 Q4 R4 S4 14.05 32.66 0.18 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I re arrange numbers
You're welcome - thanks for feeding back.
Pete On Nov 12, 6:13*pm, Raz wrote: thanks, exactly what i was looking for, "Pete_UK" wrote: Use Data | Text-to-columns and specify <space as the delimiter. Just work through the Wizard. Hope this helps. Pete On Nov 12, 5:20 pm, Raz wrote: I copied and pasted a table of numbers from another file (converted a pdf to excel) that looks like this. (only 4 rows shown here) 102050903818W400 * 1 * *6 * 7.60 334.10 *38.86 * 214.26 * 211.82 * *28.29 * * -14.05 * * 32.66 * *0.18 102050903818W400 * 1 * *7 * 7.60 338.90 *38.98 * 253.24 * 250.46 * *33.01 * * -16.11 * * 37.81 * *0.49 102050903818W400 * 1 * *8 * 7.40 335.30 *38.86 * 292.10 * 288.99 * *37.69 * * -18.08 * * 42.89 * *0.39 102050903818W400 * 1 * *9 * 7.40 336.10 *38.84 * 330.94 * 327.51 * *42.24 * * -20.14 * * 47.88 * *0.08 All these numbers are in the first column, and with spaces (more than one) between them. I would like to separate them into different columns with a simple equation or function. IS THIS POSSIBLE?? please help. I want these numbers to be like this (Now they are all in A4 to A 160) H4 * * * * * * * * * * * * * * I4 *J4 * K4 * L4 * * * * *M4 * * * N4 * * * * O4 * * * * P4 102050903818W400 * 1 * *6 * 7.60 334.10 *38.86 * 214.26 * 211.82 * *28.29 Q4 * * * * *R4 * * * S4 14.05 * * 32.66 * *0.18- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I re-arrange numbers in a column? | Excel Discussion (Misc queries) | |||
Arrange numbers in a sequence | Excel Worksheet Functions | |||
Arrange Windows | Excel Discussion (Misc queries) | |||
re-arrange text | Excel Worksheet Functions | |||
How do I arrange numbers in asending order in Excel? | Excel Discussion (Misc queries) |