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
|