I want to pull out only the last name. I can't use a MID function because the last names are all different lengths. What is the best way to do this?
Doe, John I want it to tell me Doe
Deer, Jon I want it to tell me Deer
Andres, Mark I want it to tell me Andres
Thanks for all your help!!
Stacy
Doe, John I want it to tell me Doe
Deer, Jon I want it to tell me Deer
Andres, Mark I want it to tell me Andres
Thanks for all your help!!
Stacy