Split First/Last Name

  • Thread starter Thread starter Shannon
  • Start date Start date
S

Shannon

How can I split an old field that was first and last name
to be in two fields: FirstName and LastName? They are
only separated by a space.
 
In VB Help, check out the Left(), Mid() and InStr() functions.
 
You must log in or register to reply here.

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

Splitting Imported "Last,First" Names 2
Getting a message box program to run (Page 43 of 'BeginningProgramming with VBA' by Duane Birnham) 11
splitting a field into two fields; one in () 2
Access Creating names from fields in access database. 0
Split LastName, First Name column into 2 seperate columns 9
HOW TO SEPARATE NAME FIELD 8
Access Access SQL to split a name 1
Access to split First and Last name 0

Back
Top