Thread: Like Character?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Like Character?

Is there a character in excel that represents "like"? I need to use the following formula:

=SUBSTITUTE(A3," ($XX.XX)","")

Where the old text may be any dollar amount (1.93, 5678.35, 10000.00 ...)

TIA
-Chris