View Single Post
 
Old 08-24-2009, 04:05 PM
MikeWM MikeWM is offline Windows XP Office 2003
Novice
 
Join Date: Aug 2009
Posts: 4
MikeWM is on a distinguished road
Default

Sure, just insert an error check:

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


Cheers.
Reply With Quote