Excel 2002 : How to segregate text into columns ?

[Mr. Low]

Dear Sir ,

I have the folowing text at Cell A2:A3 It is copied from MS Outlook and MS
Word to the spreadsheet.

A B
C D

2 2120 John 21478954 9/4/06 421.65
3. 2158 Sally 21450140 8/4/06 321.00

May I know what formula I must input at cell A1 and copy down to A3 to
segregate the test into columns in the worksheet as follows:

A B C D E
2 2120 John 21478954 9/4/06 421.65
3. 2158 Sally 21450140 8/4/06 321.00


Thanks

Low Seng Kuang

 

[Gord Dibben]

Try Data>Text to Columns>Space delimited.


Gord Dibben MS Excel MVP

 

[Mr. Low]

Hello Gord,

Yes, it works.

Many thanks for your info.


Kind Regards

Low Seng Kuang

 

[Gord Dibben]

Thanks for the feedback.

I also noted your post thanking MS and the contributors.

Nice to see a post of that nature.


Gord

Hello Gord,

Yes, it works.

Many thanks for your info.


Kind Regards

Low Seng Kuang

Gord Dibben MS Excel MVP