Pull out lastname
"WLMPilot" wrote:
Cell A1 = "John Doe" (without quotes)
In a macro, I have the following:
name = Range("A1").Value
How to I pull out just the last name of the person in the variable name and
place it in the variable, lastname?
Thanks,
Les
|