E
Excel-General
I think I almost have but am giving up. The fname lname string is
concatenated together with a space and I need to parse out the Lname.
Am i somewhat close?
sStr = UserForm1.g_fNameLName
Lname = Left(sStr, (InStr(1, sStr, " ")) - 1)
thanks,
concatenated together with a space and I need to parse out the Lname.
Am i somewhat close?
sStr = UserForm1.g_fNameLName
Lname = Left(sStr, (InStr(1, sStr, " ")) - 1)
thanks,