**Excel **has a multitude of **symbols** to choose from. When combined with a number, special characters or symbols have 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**.

## Download Practice Workbook

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

## 3 Handy Approaches to Add Symbol Before a Number in Excel

Weâ€™ve represented some **symbols** and numbers in the image below. Weâ€™d want to combine them into one cell to make it more comprehensible and significant. To accomplish this, weâ€™ll use the ** Symbols **group,

**, and finally,**

*the CHAR function***. To add a symbol before a number, use the methods listed below.**

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

First of all. We will use the ** Symbols **group from

*Excelâ€™s**tab to add symbols.*

**Insert****Step 1: Open the Symbols Option**

- Firstly, select a cell (
).*B5*

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

**Step 2: Insert Symbols**

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

- Finally, click on
to go back to the spreadsheet.*Close*

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

- Choose the preferred symbols to insert in the column.

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

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

`=B5&" "&C5`

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

- Finally, drag down the
to auto-fill all the cells.*AutoFill Tool*

**Read More: ****How to Type Math Symbols in Excel (3 Easy Methods)**

**Similar Readings**

**Put 0 in Excel in Front of Numbers (5 Handy Methods)****How to Insert Rupee Symbol in Excel (7 Quick Methods)****Insert Tick Mark in Excel (7 Useful Ways)****How to Type Delta Symbol in Excel (8 Effective Ways)****Type Diameter Symbol in Excel (4 Quick Methods)**

### 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

**under**

*ASCII Code***.**

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

- The corresponding
of the symbols we used previously are listed in the graphic below.*ASCII codes*

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

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

`=CHAR(B5)`

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

- Thus,
**auto-fill**the column by using the*AutoFill Tool.*

**Step 3: Join Two Cells**

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

`=C5&" "&D5`

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

- 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

**number in the**

*ASCII Code***box. Make sure that, the number system is in**

*Symbol*

*decimal.***Read More:** **Excel Formula Symbols Cheat Sheet (13 Cool Tips)**

### 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 **

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

**Step 2: Apply Format Cells **

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

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

- Finally, click
to see the first result that the plus*OK***(+)**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 (3 Handy Methods)**

## 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.

We, the **Exceldemy **Team, are always responsive to your queries.

Stay with us and keep learning.

## Related Articles

**How to Insert Degree Symbol in Excel (6 Suitable Methods)****Insert Symbol in Excel Header (4 Ideal Methods)****How to Insert Symbol in Excel Footer (3 Effective Ways)****Put Equal Sign in Excel without Formula (4 Easy Ways)****How to Insert Greater Than or Equal to Symbol in Excel (5 Quick Methods)****Insert square root symbol in Excel (7 easy ways)****How to Insert Less Than or Equal to Symbol in Excel (5 Quick Methods)**