Hi guys Is it possible to do a find and replace on the following.
AA2 AB2 AC2 AD2 to AA$2 AB$2 AC$2 AD$2. using the find and replace
in Excel? Or is there another way? Thanks
Max
Hi guys Is it possible to do a find and replace on the following.
AA2 AB2 AC2 AD2 to AA$2 AB$2 AC$2 AD$2. using the find and replace
in Excel? Or is there another way? Thanks
Max
=LEFT(A1,2)&"$"&RIGHT(A1,1)
Not VBA but would work with the example you provided.
"To a man with a hammer everything looks like a nail." - Mark Twain
If it is a formula, select the cell, in the formula bar select the reference you want to change and press F4
Thanks that works