How to Remove the Dollar Sign in Excel – 7 Methods

The pre-formatted dataset shows the dollar sign ($) before the Price value.

Dataset-How to Remove Dollar Sign in Excel


Method 1- Using the Format Cells Feature to Remove the Dollar Sign

Step 1:

Select the whole Range ( D4:E18).

Step 2:

Right-click any selected cell and choose Format Cells.

Format cells-How to Remove Dollar Sign in Excel

Step 3:

In the Format Cells window, change the Symbol to None an click OK.

Format cells symbol

You can open the Format Cells dialog box by pressing CTRL+1.

This is the output.

Format cells result-How to Remove Dollar Sign in Excel

Read More: How to Remove Currency Symbol in Excel


Method 2: RIGHT LEN Function to Remove Dollar Sign

Use the RIGHT and LEN functions. To use the RIGHT function, transform the values to Text.

Step 1:

Enter an apostrophe () before the values (with the dollar sign).

Right Len function-How to Remove Dollar Sign in Excel

  • Repeat the step.
  • Press ENTER for every cell.

This is the output.

Right LEN function

 

Step 2:

Enter the following formula in any adjacent cell (here, F4)

=RIGHT (E4, LEN(E4)-1)

 In the formula:

LEN(E4)-1; passes the total character length by subtracting 1 character.

RIGHT (E4, LEN (E4)-1); returns all the characters from the right.

Right Len formula

Step 3:

  • Press ENTER.
  • Drag down the Fill Handle to see the result in the rest of the cells.
  • This is the output.

Right LEN final result


Method 3 – Using the Find and Replace Feature to Remove the Dollar Sign

The Find and Replace feature also requires values to be in text format. Repeat Step 1 in Method 2.

Step 1:

Go to Home Tab > Find & Select (In Editing) > Select Replace.

Find and Replace -How to Remove Dollar Sign in Excel

Step 2:

  • In the Find and Replace dialog box, enter the dollar sign ($) in Find What.
  • Keep Replace With empty.
  • Click Find All.

All the cells containing the dollar sign ($) are displayed.

Find and Replace dialog box

Step 3:

  • Click Replace All.
  • Click Close.

Find and Replace Replace All

This is the output.

Find and Replace Final Result-How to Remove Dollar Sign in Excel


Method 4 -Using the VALUE Function to Remove the Dollar Sign

Use the VALUE function. The syntax of the VALUE function is

VALUE (text)

The values must be in text format. Repeat Step 1 in Method 2 for the TotalPrice column.

Step 1:

  • Enter the formula in a blank cell (here, F4).
 =VALUE(E4)

VALUE formula-How to Remove Dollar Sign in Excel

 Step 2:

  • Press ENTER.
  • Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

VALUE formula-How to Remove Dollar Sign in Excel

Related Content: How to Remove Dollar Sign in Excel Formula


Method 5 – Using the SUBSTITUTE Function to Remove the Dollar Sign

Use the SUBSTITUTE function. The syntax of the function is

SUBSTITUTE (text, old_text, new_text, [instance_num])

text; refers to any text or cell reference.

old_text; defines the text to replace.

new_text, the text to use.

[instance_num]; the occurrences of the old_text.

Step 1:

Enter the following formula in E4.

 =SUBSTITUTE(E4,CHAR(36),””)

 

E4; is the cell reference.

CHAR (36); is the old_text with the dollar sign ($).

“”; results in the new_text as blank.

Substitute function-How to Remove Dollar Sign in Excel

 Step 2:

  • Press ENTER.
  • Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

Substitute function-How to Remove Dollar Sign in Excel

To remove the dollar signs in the UnitPrice column, repeat Steps 1 and 2.


Method 6 – Using the REPLACE Function to Remove the Dollar Sign

Use the REPLACE function. The syntax is:

REPLACE (old_text, start_num, num_chars, new_text)

old_text;  the text in which you want to replace the character.

start-num; the position of the character inside the old_text.

num_chars; the number of characters inside the old_text.

new_text; is the new text.

Transform the values to text following step 1 in Method 2

 Step 1:

  • Enter the formula in F4.
=REPLACE(E4,1,1,””)

E4; is the old_text.

1; is the start_num.

1; is the num_chars.

“”; is the new_text.

Replace function-How to Remove Dollar Sign in Excel

Step 2:

  • Press ENTER.
  • Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

 

Replace function result-How to Remove Dollar Sign in Excel

Read More: How to Remove Pound Sign in Excel


Method 7 – Using the Flash Fill to Remove the Dollar Sign

Step 1:

  • Enter one or two values without the dollar sign.

Flash Fill feature-How to Remove Dollar Sign in Excel

Step 2:

  • Select the whole range and go to the Data Tab > Flash Fill (in Data Tools)

Flash Fill

This is the output.

Flash Fill final result-How to Remove Dollar Sign in Excel


Dataset for Download


 

Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo