How to copy formula without copying the dollar sign

**Roshanexcel** · 08-12-2012, 04:35 AM

Say I want to copy the formula in a cell to other cell. Formula in the cell from where i want to copy is $A$1*$B$3. When I copy this formula into a new cell I will get $A$1*$B$3 , but I want the formula to be ( Without Dollar Sign. ie relative refference ), so it will be a formula without dollar and depending on which cell I paste the alphabets and numerics will change accordingly.

Please note in my original file the formula is a 7 line formula so I cant manually make changes ...unless i have like an hour.

Help will be highly appreciated as it will save me from spoiling my Sunday

Roshan

**JBeaucaire** · 08-12-2012, 04:46 AM

You can highlight the cell(s) in question
Press CTRL-H to open the REPLACE wizard
Search for: $
Replace with: (leave blank)
Under the Options, Look In Formulas

**macropod** · 08-12-2012, 04:48 AM

Hi Roshan,

Is there a reason you can't just use Find/Replace to simply delete the $ characters?

**Roshanexcel** · 08-12-2012, 07:12 AM

Hi Jerry / Paul,

Thanks for the reply. Stepping out. Will check it once I am back. I think it should work. Thanks a ton guys, this forum is life saver. Love it .