Breaking apart first and last names

G

Guest

I know how to concatinate a first name field with a last name field, but how
do I take a list of names (i.e. JAMES SMITH) and break them apart into a
first name field and a last name field? Thanks for any suggestions.
 
A

Alan Beban

LyndieBee said:
I know how to concatinate a first name field with a last name field, but how
do I take a list of names (i.e. JAMES SMITH) and break them apart into a
first name field and a last name field? Thanks for any suggestions.
Click to expand...

Check out Data|Text to Columns

Alan Beban
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate First, Last Names 2
Data separation 1
splitting Last Name, First Name 4
Matching Names 5
How do I separate first and last names into two columns? 2
Search two columns in list for first and last name and return Id 4
complicated text to column 4
reverse enties in a field 2

Top