Split Name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to split a name into strFirstName and strLastName. The field being
split is NewData. I copied the information below and it works nicely for
strFirstName but I don't know how to get the strLastName field. I'm not a
programmer and I was hoping to just replace InStr with InStrRev but nothing
is ever that easy. Can anyone help me? Thanks!

strFirstName = Mid([NewData], InStr([NewData], " "))
 
Thank you very much. It was more than helpful since it gave me so many
options for other fields too. I'm going to give it a try and see what
happens.

freakazeud said:
Hi,
you might find this article helpful:
http://support.microsoft.com/kb/q115915/
HTH
Good luck
--
Oliver
Admin Specialist & Computer Science Major @ UMD - Go Terps - :)
http://www.oli-s.de


Ann said:
I need to split a name into strFirstName and strLastName. The field being
split is NewData. I copied the information below and it works nicely for
strFirstName but I don't know how to get the strLastName field. I'm not a
programmer and I was hoping to just replace InStr with InStrRev but nothing
is ever that easy. Can anyone help me? Thanks!

strFirstName = Mid([NewData], InStr([NewData], " "))
Click to expand...
Click to expand...
 
Back
Top