Need to add a text suffix to the end of "all words" by searching for their prefix

[lorilewis07]

For EXAMPLE:

Changing DR_STEIN PROFESSOR
to DR_STEIN(DUKE) PROFESSOR
by adding (DUKE) to all cells with DR_

Is there a find/replace for that? or other search?

Best regards,
-Lori

[cbatrody]

Hi,

Try the following:

=LEFT(A1,SEARCH(" ",A1,1)-1)&"(DUKE)"&RIGHT(A1,LEN(A1)-SEARCH(" ",A1,1)+1)

considering 'DR_STEIN PROFESSOR' is in A1

[lorilewis07]

Excellent!!!!

Thank you so much this is the result I am looking for

Best regards,
-Lori

[cbatrody]

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.