Substitute each instance of "B"in a range with value in Col A

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AMK - 12 Jun 2005 22:46 GMT

need to substitute each instance of "B" in a range B4..g24 with the value in
the Corresponding row, Col A.

Signature

Reply to this Message

Peo Sjoblom - 12 Jun 2005 22:55 GMT

You could use a formula like

=SUBSTITUTE(UPPER(B4),"B",$A4)

if you want "B" and "b" replaced if you only want "B" replaced

=SUBSTITUTE(B4,"B",$A4)

copy across five columns, then down, once done you can copy and paste
special as values and replace the old table

Signature

Regards,

Peo Sjoblom

(No private emails please)

> need to substitute each instance of "B" in a range B4..g24 with the value
> in
> the Corresponding row, Col A.

Reply to this Message

Dave Peterson - 13 Jun 2005 02:29 GMT

And maybe one more variation?

=SUBSTITUTE(SUBSTITUTE(B4,"B",UPPER($A4)),"b",LOWER($A4))

> You could use a formula like
>
[quoted text clipped - 19 lines]
> > --
> > Al

Signature

Dave Peterson

Reply to this Message

AMK - 13 Jun 2005 06:02 GMT

Thanks but neither solution appears to work. I need to exchange each instance
of "B" in the Range with the Value in Col A same Row as the "B".

> need to substitute each instance of "B" in a range B4..g24 with the value in
> the Corresponding row, Col A.

Reply to this Message

Dave Peterson - 13 Jun 2005 12:36 GMT

You'll need the same formula for each cell in that range.

If you put the formula you want in column H4 and drag to M4, then select H4:M4
and drag to row 24, it might just work ok.

> Thanks but neither solution appears to work. I need to exchange each instance
> of "B" in the Range with the Value in Col A same Row as the "B".
[quoted text clipped - 3 lines]
> > --
> > Al

Signature

Dave Peterson

Reply to this Message

AMK - 13 Jun 2005 16:11 GMT

Yes, this works just fine. I didn't quite understand it before. Thanks

> You'll need the same formula for each cell in that range.
>
[quoted text clipped - 8 lines]
> > > --
> > > Al

Reply to this Message