Mid function

M

Maria

Using this function returns the formula, not the answer.
How can I get it to display the result, not the formula?
Thanks,
 
J

Jacob Skaria

Make sure the cells are not formatted to Text...Right click>Format
Cells>Number>Select General..

In Cell A1 type 'Maria'

In B1 try the formula
=MID(A1,3,1)

If this post helps click Yes
 
B

Bob Phillips

Where are you using it, and how? In a worksheet it returns the result, part
of, for me.
 
Top