Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Round Numbers in Excel: ROUND, ROUNDUP, ROUNDDOWN and MROUND

Excel can round numbers in two very different ways: by changing how a number is displayed, or by changing the number itself. The difference matters for prices, tax, payroll and any total that must add up exactly. This guide explains the six rounding functions you will use most, ROUND, ROUNDUP, ROUNDDOWN, MROUND, CEILING and FLOOR,

Standard

How to Capitalize the First Letter in Excel: UPPER, LOWER and PROPER

Names, titles and product lists often arrive in the wrong case: all capitals, all lowercase or a random mix. Excel has three functions for changing case, UPPER, LOWER and PROPER, and a simple formula for capitalizing only the first letter of a sentence. This guide shows how to use each, how to capitalize the first

Standard

How to Remove Spaces in Excel: TRIM, SUBSTITUTE, Find and Replace

Extra spaces are one of the most common reasons that Excel formulas fail. A VLOOKUP does not find a name because it has a space at the end, a count of unique customers is too high because “Ali” and “Ali ” look the same but are different, and numbers pasted from a website refuse to

Standard

How to Combine Text in Excel: CONCAT, TEXTJOIN and the Ampersand

To combine text in Excel, you can join the values of two or more cells with the ampersand, the CONCAT function, the TEXTJOIN function or Flash Fill. These tools are used to build full names from first and last names, create addresses, make product codes and prepare data for mailing. The basic idea is simple,