Forum Discussion
RIGHT, LEFT & MID function
I don't understand why the RIGHT, LEFT & MID functions are not producing the results I am expecting. The information I need is displayed in the 'fx' dialogue box, however, when I come out of ...
I am in 'Automatic' mode; although I'm not sure what that means. Still doesn't work? Not sure what's going on
One more if Show Formula is checked
Or another dozen of reasons. Discussion is too abstract.
- I went internal to a colleague whom I thought may have worked with Excel and different functions. He told me to press 'ctrl + ~'. VOILA!!! It worked. Obviously it's a keyboard shortcut that toggles between the action of the actual function and the syntax of the function.
Thank YOU all who responded. Love this community and the collaborative nature of everyone.That is shortcut for Show Formulas on ribbon