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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

need to substitute each instance of "B" in a range B4..g24 with the value in
the Corresponding row, Col A.
 
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

--
Regards,

Peo Sjoblom

(No private emails please)
 
And maybe one more variation?

=SUBSTITUTE(SUBSTITUTE(B4,"B",UPPER($A4)),"b",LOWER($A4))
 
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".
 
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.
 
Back
Top