Convert hundreds of absolute references to relative?

schmadly

Board Regular
Joined
Mar 29, 2006
Messages
79
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?
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

schmadly

Board Regular
Joined
Mar 29, 2006
Messages
79
Yikes - I would like to blame monday morning for not thinking of this. Thanks, that will work.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,406
Messages
5,547,759
Members
410,811
Latest member
adustin42
Top