M Maria Oct 23, 2009 #1 Using this function returns the formula, not the answer. How can I get it to display the result, not the formula? Thanks,
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 Oct 23, 2009 #2 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
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 Oct 23, 2009 #3 Where are you using it, and how? In a worksheet it returns the result, part of, for me.
