View Single Post
  #8   Report Post  
yarp
 
Posts: n/a
Default

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