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)))

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)))

True

Hadnt thought of the simplest way!

Thanks

"Kevin Smith" wrote:

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)))

The below formula will remove the $ symbol from your formula. But from my
point of view if you remove the $ symbol and if you paste it to other cells
then the range will get affected.

Anyway I have given below the formula which you have asked for

=SUBSTITUTE(A2,"$","")

(Here change the Cell Reference of A2 to your desired celll)

All the Best!!!

--------------------
(MS-Exl-Learner)
--------------------



"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)))

Have you tried this? It will return a string result, not a formula
that can be executed.

Pete

On Sep 8, 10:01*am, MS-Exl-Learner
wrote:
The below formula will remove the $ symbol from your formula. *But from my
point of view if you remove the $ symbol and if you paste it to other cells
then the range will get affected.

Anyway I have given below the formula which you have asked for

=SUBSTITUTE(A2,"$","")

(Here change the Cell Reference of A2 to your desired celll)

All the Best!!!

--------------------
(MS-Exl-Learner)
--------------------



"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;"";S*UMIF($B$6:$B$48;$B53;H$6 :H$48)))- Hide quoted text -

- Show quoted text -