you can do text to column with <space as delimiter but the last name may
not be in the same column


RobertC wrote in message
...
Trying to extract last name from a cell (db field) which contains names
like:

John Doe
John B. Doe
J.B. Doe

Various combinations of formulas such as =Right(C17,Len(c17)-FIND(" ",
C17))
Can't find the right combination to do the job.

Thanks