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 symbol in Excel. We will use a sample dataset containing Product ID, Products, State and Sales where the sale values have currency symbol.

how to remove currency symbol in excel


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.

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

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

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

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

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

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.


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

Mahbubur Rahman

Mahbubur Rahman

Mahbubur Rahman is a highly skilled and experienced professional with a strong background in both engineering and business administration. With an impressive technical skill set and a passion for innovation and problem-solving, Mahbubur has achieved great success in his field.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo