Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have come across a function I do not understand.
1. Input Thursday, October 27, 2005 8:59:09 AM Formula =(--RIGHT(B2,LEN(B2) - (FIND(",",B2)+1))) Result (this is the result I wanted) 10/27/05 8:59 AM 2. Input Thursday, October 27, 2005 8:59:09 AM Formula =(RIGHT(B3,LEN(B3) - (FIND(",",B3)+1))) Result ( this is not the result i wanted) October 27, 2005 8:59:09 AM Why does putting "--" before "RIGHT" give me the desired result? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |