Maybe if you provide a sample of your formula; how it looks now and what you
want it to look like after the change, that may inspire someone to reply.

Rob

"CC" wrote in message
...
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