PDA

View Full Version : Using excel find and replace



Tenspeed39355
12-21-2012, 06:59 AM
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

david000
12-21-2012, 03:44 PM
=LEFT(A1,2)&"$"&RIGHT(A1,1)

Not VBA but would work with the example you provided.

jolivanes
12-22-2012, 12:24 AM
If it is a formula, select the cell, in the formula bar select the reference you want to change and press F4

Tenspeed39355
12-25-2012, 06:52 AM
Thanks that works