If you work with monetary data in Google Sheets, you may sometimes find yourself wanting to remove the currency symbol. Whether it’s a dollar sign ($/€) or an abbreviation like USD, it’s possible to remove it without affecting the underlying value. In this tutorial, I’ll show you how to remove the dollar sign in Google Sheets and provide some additional tips that can be applied to any other currency symbol as well. So let’s get started!
Remove Dollar Sign By Changing the Formatting
One of the easiest ways to remove the dollar sign is by changing the cell formatting. This won’t affect the actual value, but simply the way it’s displayed. Here’s how you can do it:
- Select the dataset where you want to remove the dollar sign.
- Click on the ‘Format’ option in the menu.
- Go to the ‘Number’ option.
- Click on the ‘Number format’ option.
By following these steps, you’ll change the cell formatting to only show the number without the dollar sign. You can also adjust the decimal places if needed.
Remove Dollar Sign Using a Formula or Find and Replace
In some cases, you might come across datasets where a dollar sign appears before every number. In these situations, you can use formulas or the Find and Replace tool to remove the dollar sign.
Using a Formula
If you want to remove the dollar sign using a formula, you can use the following approach:
The formula uses the RIGHT function to extract all the characters from the right side of the cell, except for the first two characters (the dollar sign and any space characters). The LEN function helps determine the total number of characters in the cell, and subtracting 2 removes the dollar sign and space characters from the beginning.
Using Find and Replace
In case the dollar sign appears consistently before the number you want to extract, you can use the Find and Replace tool. Here’s how:
- Select the dataset from which you want to remove the dollar sign.
- Hold the Control key and press the H key (or Command and H if you’re using a Mac) to open the Find and Replace dialog box.
- In the ‘Find’ field, enter ‘$ ‘ (dollar sign followed by a space character).
- Leave the ‘Replace with’ field empty.
- Click on the ‘Replace all’ button.
Following these steps will instantly remove all the dollar signs from the dataset.
These are a few ways you can remove a dollar sign in Google Sheets. By changing the cell formatting or using formulas and the Find and Replace tool, you can customize the appearance of your monetary data. I hope you found this tutorial useful. For more similar tips and tricks, check out Mr Reviews.