Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
Firstname Lastname Field, Split two cells
Good Morning Everyone,
We have an Excel file where the contact name is in ONE FIELD. We want to seperate the FirstName and LastName and put them in TWO FIELDS. Can anyone tell me how to do this? Right now this is how the database is: FieldNames Contact Anthony Smith This is what I'd like to acheive: FieldNames FirstName LastName Anthony Smith Thanks! Sincerely, Anthony Smith In God We Trust! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FirstName, LastName and vice versa | Excel Worksheet Functions | |||
Splitting firstName from Surname | Excel Worksheet Functions | |||
Split cells | New Users to Excel | |||
Split field based on number of characters and space | Excel Worksheet Functions | |||
Seperate Cell Information (lastname, firstname) | Excel Discussion (Misc queries) |