Hi
try:
=MID(A1,LOOKUP(2,1/(MID(A1,seq,1)=" "),seq)+1,1024)

where seq is a defined name ('Insert- Name - Define') with the formula
seq: =ROW(INDIRECT("1:1024"))

"RobertC" wrote:

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