I want to separate data (text) by the space between the words?

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

Guest

Using MS Access how can I separate text in a field by the spaces? I have a
name field where the users entered first and middle name into one field and I
want to separate the data into two fields.
 
Using MS Access how can I separate text in a field by the spaces? I have a
name field where the users entered first and middle name into one field and I
want to separate the data into two fields.
Click to expand...

FirstName:Left([FullName],InStr([FullName]," ")-1)
MiddleName:Mid([FullName],InStr([FullName]," ")+1)
 

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

Multi-word string from one field to two fields 2
breakdown adresses into separate fields 1
Spacing in Customer's Name 1
Removing excess spaces in data 7
Separating Last Name, First Name into Two Fields 4
First Name Variations - Split MI from First Name 4
Extracting a word from a long text field 5
can i separate a name field into 2 separate columns? 8

Back
Top