Problem with MID (any text) Command
Did you try reentering the formula after changing the format to General? Hit
F2, then Enter.
HTH,
Elkar
"Scott" wrote:
Hello,
I am having a problem getting my MID command to work. It's not necessarily a
problem with the MID command but rather any text command (MID, RIGHT, or
LEFT).
I've input the MID command =MID(cell,9,5) hoping that the formula would
return five characters. Unfortunately, the only output I get is my formula
"=MID(cell,9,5)" as opposed to seeing the five characters that start in the
ninth spot.
Here's what I've already done:
1. I've already gone to Tools - Options and "Formulas" is unchecked.
2. I've already gone to Format - Cells and changed the format to General
and also tried Number.
How can I get this formula to return the five characters I'm looking for
instead of having Excel just show me my formula?
Thanks in advance.
-Scott
|