Extracting just the last name in a text string

I have a worksheet where I need to enter a physicians name, e.g. Joe Blow, MD. Then there is another worksheet that addresses the same physician, but as Dr. Blow. Is there a formula I could use that will allow me to not have to re-enter the Dr.'s last name in the second cell; one that will extract just the last name from the first worksheet? The good thing is, there is always a comma MD (", MD") after the name in the first worksheet.

Any ideas?

Hi there,

See if changing the sheet reference (Sheet1) and the cell reference (A2) for your specific needs in the following formula does the job:

=MID(Sheet1!A2,SEARCH(" ",Sheet1!A2)+1,SEARCH(", ",Sheet1!A2)-1-SEARCH(" ",Sheet1!A2))

HTH

Robert