imported Data

[Steve Blostin]

Hi
I imported a spreadsheet frim excel into Access. The spreadsheet had a very large list of names. The full name was in one field. Obviously when the data was imported to access, each full name went into one field. . Is therre an easy way to separate first and last name from one field into two separate fields. in my access database.

 

[Jim/Chris]

If it is just first name and last name you can use the
following code but remember there are the exception like
John Van Dunn. Personnaly I would do this before I imported

strName = "Mr. First LastWordRightHere"
? right(strName, len(strName) - instrrev(strName," "))
LastWordRightHere

? left(strName, instrrev(strName, " ")-1)
Mr. First

Jim

-----Original Message-----
Hi,
I imported a spreadsheet frim excel into Access. The

spreadsheet had a very large list of names. The full name
was in one field. Obviously when the data was imported to
access, each full name went into one field. . Is therre
an easy way to separate first and last name from one field
into two separate fields. in my access database.