| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to separate FirstName and LastName ?
I've got one column that has names in it...
Joe Smith Wilbur Jones Hank Williams etc... I want to separate the FirstName and LastName into columns. I'll copy the data to other columns, then... How do I remove all characters AFTER the first Space (= FirstName)? How do I remove all characters UP TO and including the first Space (= LastName)? I understand that won't work for all names, like... T S Elliott but it will work for most. Thanks in advance, people. Mark246 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LastName, FirstName covert to FirstName LastName | Excel Discussion (Misc queries) | |||
| How to change lastname, firstname to firstname lastname in Excel? | Excel Discussion (Misc queries) | |||
| Firstname Lastname Field, Split two cells | Excel Worksheet Functions | |||
| FirstName, LastName and vice versa | Excel Worksheet Functions | |||
| Seperate Cell Information (lastname, firstname) | Excel Discussion (Misc queries) | |||
Threaded Mode
