3 Winning Excel Text Functions!

#1: Use TRIM to remove whitespaces in text. In the example below, ”   James  Johnson  ” has leading and trailing white spaces. TRIM removes the leading and trailing spaces and converts the middle set of whitespace into just one whitespace. It does a great job of cleaning up extra whitespaces that may come from data you’ve imported. #2: Use PROPER to …

3 Winning Excel Text Functions! Read More »

Use Excel’s Status Bar to quickly see Sum, Avg & Count!

The status bar automatically gives you the sum, average and count of any data you highlight by default! In the example below – I’ve highlighted some temperature values. At the bottom, the status bar has automatically given me numbers for the average of those values, the count and the sum! These numbers would change if I highlight …

Use Excel’s Status Bar to quickly see Sum, Avg & Count! Read More »