Thread: What is the "--" used for - or how do I ask excel for help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brad
 
Posts: n/a
Default What is the "--" used for - or how do I ask excel for help
There are many formulas that I see that have a "--". What are they used for,
or how do I ask Excel for help to read more about this topic.

Example

=IF(ISERR(--(A1)),LEFT(A1,MATCH(FALSE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LE
N(A1))),1)),0)-1),A1)

Reply With QuoteReply With Quote