Pull Out Last Name
Hi:
I am looking for a function in Excel to extract the LAST NAME from a cell
that looks like:
Justin Kenney
I want the formula to give me only the last name (ie Kenney)
Can anyone help with a formual (maybe the RIGHT function) that looks RIGHT
TO LEFT for the 1st space...and then gives me everything to the RIGHT of the
space
Thanks
Warren
|