Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to extract a person's last name from a field & put it into another for
sorting purposes. If their name is Bud Line, I want to put Line into a different field. If their name is Betsy Sue Color, I want to put Color into a different field. I think their should be a way to search for the space starting from the right side, but I don't know how. The problem I'm having is if their name is listed as first, middle and last. |