Thread: Firstname Lastname Field, Split two cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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!




Reply With QuoteReply With Quote