# How to Remove the Dollar Sign in Excel – 7 Methods

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

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

Step 3:

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

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

This is the output.

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

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

This is the output.

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.

Step 3:

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

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

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.

Step 3:

• Click Replace All.
• Click Close.

This is the output.

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

Â Step 2:

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

This is the output.

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

Â Step 2:

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

This is the output.

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.

Step 2:

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

This is the output.

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

Step 1:

• Enter one or two values without the dollar sign.

Step 2:

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

This is the output.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
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

Advanced Excel Exercises with Solutions PDF