ExcelBanter - Mid function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Mid function (https://www.excelbanter.com/excel-worksheet-functions/246414-mid-function.html)

Maria[_4_]

Mid function

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

Jacob Skaria

Mid function

Make sure the cells are not formatted to Text...Right clickFormat
CellsNumberSelect General..

In Cell A1 type 'Maria'

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

If this post helps click Yes
---------------
Jacob Skaria

"Maria" wrote:

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

Bob Phillips[_3_]

Mid function

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

--
__________________________________
HTH

Bob

"Maria" wrote in message
...
Using this function returns the formula, not the answer.
How can I get it to display the result, not the formula?
Thanks,

All times are GMT +1. The time now is 12:51 PM.