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

[[email protected] uk]

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

[Bearacade]

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)

[JMB]

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
>
>