Hello,

Select your range and use Find and Replace.
Search for $ and replace with nothing.

--
Kevin Smith :o)


"LiAD" wrote:

Hi,

I have the following formula is about 200 cells and I need to remove all of
the $ so that all cells are free to move when copied. Is there a way I czn
remove them all at once rather than selecting each and doing it manually?

Thanks
=IF(COUNTIF($B$6:$B$48;$B53)=0;"";IF(SUMIF($B$6:$B $48;$B53;H$6:H$48)=0;"";SUMIF($B$6:$B$48;$B53;H$6: H$48)))