Splitting Imported "Last,First" Names

[GAKDEV]

I am importing an Excel spreadsheet with where the name column is either an organization or LastName,FirstName. I am able to split off the LastName using Left and Instr functions. How do I get the FirstName out. I keep getting either a partial first name or part of the last name. The LastName and FirstName are variable in length.

 

[Cheryl Fischer]

Mid([FullName], InStr([FullName], ",")+1)

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

I am importing an Excel spreadsheet with where the name column is either

an organization or LastName,FirstName. I am able to split off the LastName
using Left and Instr functions. How do I get the FirstName out. I keep
getting either a partial first name or part of the last name. The LastName
and FirstName are variable in length.

 

[Joe Fallon]

You use Left, Mid and Instr and search for the comma separator value.

Instr tells you the position of the comma.

e.g.
Fallon, Joe

The comma is in postion 7 above.
So the last name is Left(str,7-1)

First Name is Mid(str,7+1)

You replace the 7 with your Instr function that finds the comma.
--
Joe Fallon
Access MVP

I am importing an Excel spreadsheet with where the name column is either

an organization or LastName,FirstName. I am able to split off the LastName
using Left and Instr functions. How do I get the FirstName out. I keep
getting either a partial first name or part of the last name. The LastName
and FirstName are variable in length.