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

--
A36B58K641