IF statement that adds text to a cell

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

FAQ

Thread Tools

Display Modes

08-19-2009, 09:22 PM

MikeWM

Windows XP IF statement that adds text to a cell

Office 2003

Novice

Join Date: Aug 2009

Posts: 4

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.

Cheers.

« Previous Thread | Next Thread »

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 02:07 PM.