| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spliting data
need your help again, really apreciate it :) I have all the data seperated.. except some of them contained salutations e.g. Name Mr Sam Fisher Bob Smith Mrs Carla O Toole WHICH IS NOW Name1 Mr Bob Mrs Name2 Sam Smith Carla Name3 Fisher O Name4 Toole So all the colums are out of order I have 40 000 records i need to sort Any way to seperate each colum according to spaces within the initial field?? Cheers -- blander ------------------------------------------------------------------------ blander's Profile: http://www.excelforum.com/member.php...o&userid=36486 View this thread: http://www.excelforum.com/showthread...hreadid=565157 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
| Importing Data | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Threaded Mode
