Actually what I need to do is put an absolute reference in all the cells
within a concatenated formula. I haven't found a way to do, even using
Search and Replace without updating each cell reference and the formula s
concatenating up to 7 cells. Too many to do manually. PLEASE HELP!


"billbrandi" wrote:

Is there a quick way to convert fixed cell references ($row$column) to
eliminate the $ without editing the formula and deleting the $ one keystroke
at a time? Sure would save me a lot of time.

Thanks
Bill Falzone