Thread
: [Solved]
IF statement that adds text to a cell
View Single Post
08-24-2009, 04:05 PM
MikeWM
Windows XP
Office 2003
Novice
Join Date: Aug 2009
Posts: 4
Sure, just insert an error check:
=IF(ISERR(FIND(",",A1)),A1,"Dr. "&LEFT(A1,((FIND(",",A1)-1))))
Cheers.
MikeWM
View Public Profile
Find all posts by MikeWM