string

[Maximus007]

I need some help on how to get the last name from a string. Exampl: Doe, John

How can I get just the Doe only or what function can I use to accomplish that?

 

[country73]

You could just use the "SPLIT" function and split that line on the ",".

 

[PHV]

A starting point:
strFullName = "Doe, John"
MsgBox Left(strFullName, InStr(strFullName, ",") - 1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Maximus007]

It's working great!

Thank you for sharing.