|
View Full Version : How do I separate first and last name? Noreene Patrick 09-15-2003, 12:09 PM 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 09-15-2003, 12:16 PM Article ID: Q115915 namliam 09-16-2003, 02:57 AM 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 09-16-2003, 05:57 AM Thanks to both of you IT WORKS!!!! Exactly what I needed... Noreene |