Splitting a field

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

Hello

I need to split a field into two First and Last name.

FieldA
Smith, John

Need
First Last
John Smith
 
IF you always have a comma between the two name parts:

[LastName]: Trim(Left([FieldA], InStr([FieldA], ",") - 1))
[FirstName]: Trim(Mid([FieldA], InStr([FieldA], ",") + 1))
 
Back
Top