Separation of Combination Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I sometimes receive data that includes combination information that I need to
divide into separate columns, i.e. if I need to mail merge with first name
last name and the information in my database has the name all in one column.
How do I separate Mary Smith into two separate data fields?
 
Use the InStr function to find the location of the space in the name, then
use Left and Right functions to parse the name.

FirstName = Left(FullName, InStr(1, FullName, " ") - 1)
LastName = Right(FullName, Len(FullName) - InStr(1, FullName, " ") )

Assuming FullName is the name of the field with the names.
 

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 Names 3
Excel Comparing two columns 1
Use combined name on form 7
How do I combine data from two columns into one in Access 2007 2
Stripping off a little rectangle that separates names in a fie;d 1
Combines fields 3
Combining firstname and lastname in combo box 6
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top