Excel Tip Tuesday: Fun with Formulas

Posted by Lisa on July 3, 2018 at 10:00 AM

Excel IconDo 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.

Excel Tips - Formula Fun1

And if you ever want to see more than one formula at a time, try 'Ctrl ~'. Here's the normal view of data:

Excel Tips - Formula Fun2

Here's a view of the same data after 'Ctrl ~':

Excel Tips - Formula Fun3

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.

Topics: Excel

Don't Miss a Thing!

Subscribe to our blog

Subscribe to our blog

    Recent Posts