How to Remove Currency Symbol in Excel (6 Ways)

Get FREE Advanced Excel Exercises with Solutions!

While working with Excel, sometimes we notice that our data contains values in Currency Format. Excel automatically includes a Dollar symbol for the cells formatted as currency. What if, it is not the scenario we want? We want our numeric values as it is without any currency symbol. In this article, we will see different methods on how to remove currency symbols in Excel. We will use a sample dataset containing Product ID, Products, State, and Sales where the sale values have currency symbols.

how to remove currency symbol in excel


Remove Currency Symbol in Excel: 6 Ways

In this post, we will guide you through 6 different methods including the Format tab, the Find and Replace option, and functions like VALUE, REPLACE, RIGHT, and SUBSTITUTE.


Method 1: Remove Currency Symbol Using Format Tab

The most used method to remove currency symbol in Excel is the Format tab.

Steps:

  • First, select the entire range containing the currency symbol and press CTR+1. As a result, a dialogue box will pop up.

  • Now, select None from the Symbol dropdown box and click OK.

how to remove currency symbol in excel by format tab

That’s it, we will get the result as follows.

All the currency values are converted into numbers.

Read More: How to Remove Dollar Sign in Excel Formula


Method 2: VALUE Function to Remove Currency Symbol

Using the VALUE function is another easy way to remove currency symbol and convert the value into numbers.

Steps:

  • First, type the following formula in cell F5.
=VALUE(E5)

how to remove currency symbol in excel by VALUE function

  • Now, press the ENTER key.

how to remove currency symbol in excel using VALUE function

  • Finally, drag down to AutoFill the rest of the series.

Simple.

Read More: How to Remove Sign from Numbers in Excel


Method 3: Remove Currency Symbol with SUBSTITUTE Function

Now, we will see the use of the SUBSTITUTE function to remove the currency symbol.
We will use the formula if our data are in Text values.

how to remove currency symbol in excel if text values

Steps:

  • First, type the following formula in cell F5.
=SUBSTITUTE(SUBSTITUTE(E5,"$",""),",","")

how to remove currency symbol in excel by substitute function

  • Now, press the ENTER key.

  • Finally, drag down to AutoFill rest of the series.

Here, function SUBSTITUTE(E5,”$”,””) gives the output  “1000” Further =SUBSTITUTE(“1000″,”,”,””) yields the inal result as 1000.

Read More: How to Remove Pound Sign in Excel


Method 4: Using RIGHT Function to Remove Currency Symbol

 The RIGHT function along with the LEN function can be used to remove currency symbols if the values are in text format.

Steps:

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

how to remove currency symbol in excel Right Function

  • Now, press the ENTER key.

  • Finally, drag down to AutoFill rest of the series.

how to remove currency symbol in excel RIGHT and LEN function

Here, LEN(E5)-1 yields result 4, as the currency symbol is the first character and we want to remove it, that’s why we used -1. Then = RIGHT(E5,4) will give us the output as “1000”. The RIGHT function took only the 4 characters from the right side of the cell, as we know texts are always on the right side in Excel.

Read More: How to Remove Percentage Symbol in Excel


Method 5: Remove Currency Symbol Using REPLACE Function

Here, we will see the use of another simple function REPLACE.

Steps:

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

  • Now, press the ENTER key.

how to remove currency symbol in excel with replace function

  • Finally, drag down to AutoFill rest of the series.

Here, in the REPLACE function, we’ve provided the cell reference and asked to replace the 1st character (since the currency symbol is in the 1st place) with null value (“”). Thus we’ve found the desired result.

Read More:How to Remove Dollar Sign in Excel


Method 6: Using Find and Replace Feature

If we don’t want to use a formula and our currency symbol containing cells is in Text format, Find and Replace is the easiest method to remove the currency symbol in Excel.

Steps:

  • Press CTRL+H and a dialogue box will pop up.

how to remove currency symbol in excel by find and replace

  • From the dialogue box type $ in Find what and keep the Replace with box empty and click Replace All.

how to remove currency symbol in excel by find and replace

Done. Easy.

how to remove currency symbol in excel by find and replace


Practice Section

The single most crucial aspect in becoming accustomed to these quick approaches is practice. As a result, we’ve attached a practice workbook where you may practice these methods.


Download Practice Workbook


Conclusion

That’s all for the article. These are 6 different methods for how to remove currency symbol in Excel. Based on your preferences, you may choose the best alternative. Please leave them in the comments area if you have any questions or feedback.


Related Articles


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mahbubur Rahman
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo