Splitting a field

H

Heather

Hello

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

FieldA
Smith, John

Need
First Last
John Smith
 
K

Ken Snell MVP

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))
 

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

How to fix spaces between last name comma first name 8
Splitting a Field Question 2
Excel Comparing two columns 1
Splitting Names 2
can i separate a name field into 2 separate columns? 8
Reversing name values in a field 4
reformatting a name 2
Trim Last Name 1

Top