Mahbubur Rahman
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 symbol in Excel. We will use a sample dataset containing Product ID, Products, State and Sales where the sale values have currency symbol.
Download Practice Workbook
6 Ways to Remove Currency Symbol in Excel
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, 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.
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 (2 Easy Ways)
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)
- Now, press the ENTER key.
- Finally, drag down to AutoFill rest of the series.
Simple.
Read More: How to Remove Sign from Numbers in Excel (6 Suitable Methods)
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.
Steps:
- First, type the following formula in cell F5.
=SUBSTITUTE(SUBSTITUTE(E5,"$",""),",","")
- 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 (8 Easy Methods)
Method 4: Using RIGHT Function to Remove Currency Symbol
RIGHT function along with LEN function can be used to remove currency symbols if the values are in TEXT.
Steps:
- First, type the following formula in cell F5.
= RIGHT(E5,LEN(E5)-1)
- Now, press the ENTER key.
- Finally, drag down to AutoFill rest of the series.
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 Sign in Excel (With 3 Examples)
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.
- 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 Symbol in Excel (8 Ways)
Method 6: Using Find and Replace Feature
If we don’t want to use formula and our currency symbol containing cells are in Text format, Find and Replace is the easiest method to remove currency symbol in Excel.
Steps:
- Press CTRL+H and a dialogue box will pop up.
- From the dialogue box type $ in Find what and keep the Replace with box empty and click Replace All.
Done. Easy.
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.
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.
