cell a1 mod No(abc??d) cell b1=unit size(10) a1 would be abc10d
 

example
cell a1 (abcd??ef) cell b1 (10) cell a2 would give answer (abcd10ef)

cell a1 mod No(abc??d) cell b1=unit size(10) a1 would be abc10d
 

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

--
Bearacad

-----------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...fo&userid=3501
View this thread: http://www.excelforum.com/showthread.php?threadid=57007

cell a1 mod No(abc??d) cell b1=unit size(10) a1 would be abc1
 

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