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

### Method 1 – Use Symbols Group to Add a Symbol Before a Number

Step 1: Open the Symbols Option

• 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 Close to go back to the spreadsheet.

• 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`

• Press Enter to see the first added value of the symbol and number.

• Drag down the Fill Handle to auto-fill all the cells.

### Method 2 – Apply CHAR Function to Add Symbol Before a Number

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)`

• Press Enter to see the result. The plus (+) sign will appear in cell C5.

Step 3: Join Two Cells

• Write down the formula to connect the two cells having a space between them.
`=C5&" "&D5`

• Press Enter to see the result.

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

### Method 3 – Format Cells to Add Symbol

Step 1: List the Symbols

• Make a list of symbols you want to add before the numbers.
• From the Formula Bar, copy the symbol.
• Press the Esc button.

Step 2: Apply Format Cells

• Select cell C5Â where the number is located.
• 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.

• Click OK to see the first result that the plus (+) sign is added before the number 100200.

• Repeat the procedure for the remaining operations and check the outcomes below.

## Related Articles

<< Go Back to Insert Symbol in Excel | Excel SymbolsÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Bhubon Costa

Bhubon Costa, B.Sc. in Naval Architecture & Marine Engineering from Bangladesh University of Engineering & Technology, has worked with the ExcelDemy since 2021. Currently, he has been working as a reviewer. Notably, he has written over 90 articles and led several VBA content development teams. He has a great passion for the fields of data analytics and data science. His areas of expertise include Excel VBA, Power Query, Pivot Table, Power BI, MySQL, PostgreSQL, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF