Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RAZ RAZ is offline
external usenet poster
 
Posts: 120
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RAZ RAZ is offline
external usenet poster
 
Posts: 120
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I re-arrange numbers in a column? Cheetah Excel Discussion (Misc queries) 7 February 21st 07 12:13 AM
Arrange numbers in a sequence Joe Excel Worksheet Functions 2 April 13th 06 05:42 AM
Arrange Windows Bean123r Excel Discussion (Misc queries) 0 January 24th 06 10:35 PM
re-arrange text snugs25 Excel Worksheet Functions 1 December 12th 05 02:16 PM
How do I arrange numbers in asending order in Excel? Linds Excel Discussion (Misc queries) 2 August 15th 05 03:29 PM


All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"