I don't think that will work if the number of characters to replace is not 2
(but that may not be a problem -there is, after all, only one example to go
on).

My two cents:
=REPLACE(A1,FIND("?",A1),LEN(A1)-LEN(SUBSTITUTE(A1,"?","")),A2)

Of course, I'm assuming there are no stray "?" in the text string (for
example, a "?" at the end of a question that is not intended to be replaced).


"Bearacade" wrote:


Try this.. But I am not sure if this is what you are asking..

Put this in A2:

=LEFT(A1,FIND("?",A1)-1)&A2&RIGHT(A1,LEN(A1)-FIND("?",A1)-1)


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=570079