View Single Post
Old 08-19-2009, 09:22 PM
MikeWM MikeWM is offline Windows XP Office 2003
Join Date: Aug 2009
Posts: 4
MikeWM is on a distinguished road

Try this.

=IF(FIND(",",A1)>1,"Dr. " & LEFT(A1,((FIND(",",A1)-1))))

It goes a step further and extracts the entire surname.

Otherwise, just use the find the command to identify the comma. Find returns the number of characters up to the search term (,). So if the result is > 0 then, you have found a doctor.

Reply With Quote