Do you ever need to know the number of characters in a cell? What about changing the case of text in a cell automatically? Or even something as basic but useful as removing those pesky spaces at the beginning or end of text? Try these formulas.
And if you ever want to see more than one formula at a time, try 'Ctrl ~'. Here's the normal view of data:
Here's a view of the same data after 'Ctrl ~':
To change back to the normal view, press 'Ctrl ~' again.
Leave us a comment and let readers know what Excel tips you use on a daily basis.