# How to Remove Currency Symbol in Excel (6 Ways)

Excel automatically includes a Dollar symbol for the cells formatted as currency. We will show you how to remove the currency sign from the cells. We will use a sample dataset containing Product ID, Products, State, and Sales where the sale values have currency symbols.

## Remove Currency Symbol in Excel: 6 Ways

### Method 1 – Remove the Currency Symbol Using the Format Tab

Steps:

• Select the entire range containing the currency symbol and press Ctrl + 1. A dialogue box will pop up.

• Select None from the Symbol dropdown box and click OK.

• We’ll get the result as follows.

### Method 2 – Use the VALUE Function to Remove the Currency Symbol

Steps:

• Copy the following formula in cell F5.
`=VALUE(E5)`

• Press Enter.

• Drag down to AutoFill the rest of the series.

Read More: How to Remove Sign from Numbers in Excel

### Method 3 – Remove the Currency Symbol with the SUBSTITUTE Function

Our data is formatted in Text here.

Steps:

• Copy the following formula in cell F5.
`=SUBSTITUTE(SUBSTITUTE(E5,"\$",""),",","")`

• Press Enter.

• Drag down to AutoFill rest of the series.

### Method 4 – Using the RIGHT Function to Remove the Currency Symbol

Applicable for the text format.

Steps:

• Copy the following formula in cell F5.
`= RIGHT(E5,LEN(E5)-1)`

• Press Enter.

• Drag down to AutoFill rest of the series.

Read More: How to Remove Percentage Symbol in Excel

### Method 5 – Remove the Currency Symbol Using the REPLACE Function

Steps:

• Insert the following formula in cell F5.
`=REPLACE(E5,1,1,"")`

• Press Enter.

• Drag down to AutoFill rest of the series.

The function replaces the first character from the cell (the currency symbol) with a blank character.

### Method 6 – Using the Find and Replace Feature

Steps:

• Press Ctrl + H and a dialog box will pop up.

• Put \$ in Find what and keep the Replace with box empty, then click on Replace All.

• Click OK on the notification, and you’ll get the results.

## Practice Section

Weâ€™ve attached a practice workbook where you may practice these methods.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Mahbubur Rahman

MAHBUBUR RAHMAN is a leather engineer with a talent for Excel and a passion for VBA programming. To him, programming is like a time-saving wizard, making data manipulation, file handling, and internet interactions a breeze. His skill set extends to SPSS, STATA, Deep Neural Networks, and Machine Learning. Holding a B.Sc in Leather Engineering from Khulna University of Engineering & Technology, he's shifted to become a content developer. In this role, he crafts technical content centred around Excel... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF