3 methods to add unit to cells in Excel - a step-by-step guide

In Excel, adding units to cells can be crucial for clarity and context, especially when dealing with quantities or measurements. This tutorial explores three methods to achieve this: using the Format Cells function, leveraging Kutools for Excel for efficiency, and employing formulas for dynamic unit inclusion.

Add unit to each cell with Format Cells function

As shown in the screenshot below, if you need to append the unit 'kg' to a list of quantities without influencing their underlying calculations, the Format Cells function in Excel offers a practical solution.

1. Select the data list, then right click to select Format Cells from the context menu.

2. In the popped out Format Cells dialog and under the Number tab, select Custom from the Category list, and then in the Type text box, enter 0"kg" into it.  Finally click OK.

Easily add unit to each cell in selection with Kutools for Excel

If you simply want to add units to cells without thinking about calculations, Kutools for Excel offers a straightforward solution with its 'Add Text' feature. This tool allows you to quickly append units like 'kg' to quantities in your spreadsheet.

After downloading and installing Kutools for Excel, click Kutools > Text > Add Text to open the Add Text dialog box. Then you need to configure as follows.

1. Select the list of cells to which you want to add unit.
2. In the Text box, type the unit you need into it. such as " kg" in this case.
3. Select the After last character option in Add position section.
4. Click OK to apply the feature.
   

Result

The specified unit is added to each cell in the selected range immediately.

Add unit to each cell with formula

If you simply want to add units to cells without thinking about calculations, you can also use the "&" operation to accomplish this task.

Select a blank cell next to the fist cell of the data list, and enter this formula =B2&"kg" (B2 indicates the cell you need its value, and $ is the unit you want to add to) into it, and press Enter key, then drag the AutoFill handle to the range.

Relative Articles:

• Add/ insert prefix or suffix to selected cells, rows, and columns
• Add percentage symbol for multiple numbers in cells