How do I separate first and last name?

[Noreene Patrick]

I have imported info from Excel into a table in Access...But, the name field has last name, first name in one field and I want it to have last name in one field and first name in next field...I know how to concantenate first and last name but how do I UN-concantenate?

Thanks for your help.

Noreene

 

[Rich]

Article ID: Q115915

 

[namliam]

MyName="The Mailman"
?Left(MyName,instr(myname," ") )
The
?Mid(myname,instr(myname," ")+1)
Mailman

MyName="Mailman"
?Left(MyName,instr(myname," ") )

?Mid(myname,instr(myname," ")+1)
Mailman

Regards

The Mailman

 

[Noreene Patrick]

Thanks to both of you

IT WORKS!!!! Exactly what I needed...

Noreene