Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 : How to segregate text into columns ?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
Excel 2002 Add-in: Open Database Connectivity available for Excel | Excel Discussion (Misc queries) | |||
Excel 2002 Unhide Columns Shortcut?? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |