| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seperating Text in One Field into 2 Fields EG FullName
I have a spreadsheet that I have a list of Employees names. Unfortunately the
List has there full names and I want to seperat them into First Name and Surname. the First Name Has a space after it before the surname starts. EG FullName John Smith I want to seperate these into First Name Surname John Smith Any Help would be very appreciated, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seperating Text from Columns | Excel Discussion (Misc queries) | |||
| Seperating Text from Columns | Excel Discussion (Misc queries) | |||
| seperating values from text | Excel Discussion (Misc queries) | |||
| Seperating text | Excel Discussion (Misc queries) | |||
| Seperating text if there's more than a one space between them | Excel Discussion (Misc queries) | |||
Threaded Mode
