Convert hundreds of absolute references to relative?

[schmadly]

The Issue: I have a spreadsheet with hundreds of formulas/links with absolute references in each cell. I need to remove the absolute references.

What I have tried: I cannot simply remove the absolutes from one cell and then fill the cells down because each cell has a different formula.

What I Need: So, I need a macro or something that will do a search for any "$" in a cell value and then delete it.

Any thoughts?

 

[Airfix9]

Edit and replace?

 

[schmadly]

Yikes - I would like to blame monday morning for not thinking of this. Thanks, that will work.

 

[Airfix9]

Your secret's safe with me!