Excel 2002 : How to segregate text into columns ?

G

Guest

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
 
G

Guest

Hello Gord,

Yes, it works.

Many thanks for your info.


Kind Regards

Low Seng Kuang
 
G

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
Click to expand...

Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002 : How to extract references from a list ? 6
Excel 2002 : How to sum up items by month, date and year ? 4
Excel 2002: How to split text into columns ? 2
Distinct Counts with Multiple Criteria 1
Distinct Count with Criteria 3
Excel 2002: How to write protect a cell using password ? 5
Excel 2002: How to add extension to text ? 4
Convert 3 columns into 1, as text. 2

Top