KL,
Indeed quick and even too easy for someone who knows the function
SUBSTITUTE...
Thanks!
yarp.

"KL" wrote:

Hi yarp,

PS: It may be a nice exercise to try to get with Excel functions from an
address containing $ signs to an address without $ signs...

How about this quick and easy:

=SUBSTITUTE(CELL("address"),"$","")

Regards,
KL