| 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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
|
Firstname Lastname Field, Split two cells
One way ..
Select the range of contact names Click Data Text to Columns (delimited) Click Next, check Space Finish -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Anthony Smith" wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Firstname Lastname Field, Split two cells
Use the Text to Columns feature with a space as the separator.
-- Gary's Student gsnu200707 "Anthony Smith" wrote: 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! |
|
#4
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Firstname Lastname Field, Split two cells
Parsing names can be complicated.....but, if all of the values are in the
form: Firstname (space) Lastname Try something like this: Select the list of names Then, from the Excel main menu: <data<text-to-columns Check: Delimited.......click [next] Check: Space.......click [finish] So A2: Anthony Smith will become A2: Anthony B2: Smith Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Anthony Smith" wrote: 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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
|
Firstname Lastname Field, Split two cells
Another way is
=LEFT(A3,FIND(" ",A3)-1) for the first name, and =RIGHT(A3,LEN(A3)-FIND(" ",A3)) for the last name. -- David Biddulph "Max" wrote in message ... One way .. Select the range of contact names Click Data Text to Columns (delimited) Click Next, check Space Finish "Anthony Smith" wrote in message ... 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! |
|
#6
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
|
Firstname Lastname Field, Split two cells
Thank you, thank you, thank you. that Data Text to Columns and space
worked perfectly! Thank you all for the responses. Have a blessed weekend! "Max" wrote in message ... One way .. Select the range of contact names Click Data Text to Columns (delimited) Click Next, check Space Finish -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Anthony Smith" wrote in message ... 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! |
|
#7
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
|
Firstname Lastname Field, Split two cells
You're welcome ..
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Anthony Smith" wrote in message ... Thank you, thank you, thank you. that Data Text to Columns and space worked perfectly! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| separate lastname from firstname | Excel Worksheet Functions | |||
| Is there a way to separate FirstName and LastName ? | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
