Excel has a collection of symbols to choose from. Combining a number, special characters or symbols has different meanings. In most cases, you wonâ€™t be able to put them in a single cell with a number. To represent the symbols with numbers, youâ€™ll need to add certain formulas and functions. In this tutorial, we will show you how to add a symbol before a number in Excel.

## How to Add Symbol Before a Number in Excel: 3 Ways

Weâ€™ve represented some symbols and numbers in the image below. Weâ€™d like to combine them into one cell to make it more comprehensible and significant. To accomplish this, weâ€™ll use the **Symbols **group, the **CHAR **function, and the **Format Cells** feature. To add a symbol before a number, use the methods listed below.

### 1. Use Symbols Group to Add Symbol Before a Number

We will use the **Symbols **group from the **Insert **tab to add symbols.

**Step 1: Open the Symbols Option**

- Firstly, select cell
**B5**.

- Click on the
**InsertÂ**tab. - From the
**Symbols**group, select the**Symbol**option.

**Step 2: Insert Symbols**

- After opening the
**Symbol**box, click to select the preferred symbol. - Click on
**Insert**to add the symbol to the Excel cell.

- Click on
**Close**to go back to the spreadsheet.

- As a result, the plus
**(+)**sign will be inserted in cell**B5**.

- Choose the preferred symbols to insert in the column.

**Step 3: Apply Formula to Add Symbol Before a Number**

- To add the two cell values separated by a space, type the following formula.

`=B5&" "&C5`

- Then, press
**Enter**to see the first added value of the symbol and number.

- Finally, drag down the
**Fill Handle**to auto-fill all the cells.*Â*

**Read More: ****How to Type Math Symbols in Excel**

**Similar Readings**

**How to Write X Bar in Excel****How to Use Multiply Sign in Excel****How to Insert Tick Mark in Excel****How to Insert Rupee Symbol in Excel****How to Insert Degree Symbol in Excel****How to Insert Sigma Symbol in Excel****How to Insert Square Root Symbol in Excel****How to Type Diameter Symbol in Excel**

### 2. Apply CHAR Function to Add Symbol Before a Number

You can add symbols or characters with the help of **the CHAR function**. Every symbol has a dedicated **ASCII code **under the **CHAR **function.

**Step 1: List the ASCII Code for the symbols**

- The corresponding
**ASCII codes**of different symbols are listed below.

**Step 2: Insert ASCII Codes with the CHAR Function**

- Enter the
**ASCII Code**(**43**) of the plus**(+)**sign with the**CHAR**function.

`=CHAR(B5)`

- Then, press
**Enter**to see the result. You will see that the plus (**+**) sign will appear in cell**C5**.

**AutoFill the formula**Â throughout the column.

**Step 3: Join Two Cells**

- Write down the formula to connect the two cells having a space between them.

`=C5&" "&D5`

- Finally, press
**Enter**to see the result.

- To get the results for all the cells, simply drag down the
**AutoFill**tool.

**Â Notes: **Â If you donâ€™t know the **ASCII code**, you can find the **ASCII code** number in the **Symbol **box. Make sure that, the number system is in decimal*.*

**Read More: ****How to Type Minus Sign in Excel Without Formula**

### 3. Format Cells to Add Symbol

Excel has some built-in symbols for numbers, **currency**, and plus (**+**) /minus (**â€“**). We can add them before a number by using the **Format Cells** box.

**Step 1: List the Symbols **

- Make a list of symbols you want to add before the numbers.
- From the
**Formula Bar**, copy the symbol. - Then, press the
**Esc**button.

**Step 2: Apply Format Cells **

- Select cell
**C5**Â where the number is located. - After that, pressÂ
**Ctrl**+Â**1**Â to open the**Format Cells**dialog box.

- From the
**Number**tab, select the**Custom**option. - In the
**Type**box, select a number format (**#,##0**) and paste the symbol plus (**+**) before the format. - You can see a preview in the
**Sample**.

- Finally, click
**OK**to see the first result that the plus (**+**) sign is added before the number (**100200**).

- As a result, repeat the procedure for the remaining operations and check the outcomes as shown below.

**Read More:** **How to Insert Dollar Sign in Excel Formula**

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article.

## Conclusion

I hope this article has given you a tutorial about how to add a symbol before a number in Excel. All of these procedures should be learned and applied to your dataset. Take a look at the practice workbook and put these skills to the test. Weâ€™re motivated to keep making tutorials like this because of your valuable support.

Please contact us if you have any questions. Also, feel free to leave comments in the section below.

## Related Articles

**How to Insert Sign in Excel Formula****How to Insert Symbol in Excel Header****How to Insert Symbol in Excel Footer****How to Put Sign in Excel Without Formula****How to Put Equal Sign in Excel without Formula****How to Put a Plus Sign in Excel without Formula****How to Insert Greater Than or Equal to Symbol in Excel****How to Insert Less Than or Equal to Symbol in Excel**