how do I convertext in cells a1, a2, a3 and covert to a1, b1, b2
I have addresses which were entered in cells a1, A2, A3 and so On and I need
to convert them to appear in cells a1, b2, b3 I know I have performed this
function in the past but I am drawing a blank please help.
|