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!
|