How can I substitute each instance of "B" in a range (B4..g22) with the value
in
Column A same row as the Corresponding "B". Not all cell in range have the "B"

Al