IF statement that adds text to a cell

		Microsoft Office Forums > Microsoft Word > Mail Merge
IF statement that adds text to a cell

08-24-2009, 04:05 PM

MikeWM

Windows XP IF statement that adds text to a cell

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup and If statement problem	bunnygum	Excel	1	03-24-2009 05:10 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM
Templates: automatic text generation from Rich Text content control	Chickenmunga	Word	0	10-01-2008 11:16 AM
Help - Word adds secret code? Copy to notepad?	andytaylor2006	Word	0	12-15-2006 11:00 PM
paste formated text from Word to only one Excel cell	heron	Word	1	12-06-2005 02:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:50 PM.