Hello everybody,
I have no idea how to tell excel to cut the last name of a full name (Brian Smith) and paste it into another cell (Smith).
I have a list of first and last names:
Brian Smith -> now I want excel to cut the word after the blank space (Smith) and paste it into another cell.
cell A1 =Brian Smith
cell A2= Smith
Thank you very very much!!!!!!!
I have no idea how to tell excel to cut the last name of a full name (Brian Smith) and paste it into another cell (Smith).
I have a list of first and last names:
Brian Smith -> now I want excel to cut the word after the blank space (Smith) and paste it into another cell.
cell A1 =Brian Smith
cell A2= Smith
Thank you very very much!!!!!!!