![how to clear formatting in excel cells how to clear formatting in excel cells](https://www.nsouly.com/wp-content/uploads/2020/09/How-to-Clear-Formatting-in-Excel-6.png)
![how to clear formatting in excel cells how to clear formatting in excel cells](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2015/04/excel-2010-clear-formatting-selected-1.jpg)
This will open the ‘ Find and Replace’ dialog box.Alternatively, you can just press CTRL+H from your keyboard. From the ‘Editing’ group, under the Home Tab, click on ‘ Find and Select’ and click ‘Replace’ from the drop-down menu.Select the cells containing the dollar signs that you want to remove.If you find the cells having a consistent pattern, for example, if there’s a dollar sign followed by space (or some other character) followed by the actual number, you can use the Find and Replace feature. Removing Dollar Sign by using Find and Replace In such cases, replace LEN(B2)-1 to LEN(B2)-2. Note: If your original cell had a different format, for example, if it had the dollar sign followed by a space followed by the actual number, then you would need to remove the first 2 characters. The first character of B2 was the dollar sign, so this gets removed. This means “ get the last 5 characters from cell B2”. If the original cell (B2) has 6 characters, then LEN(B2)-1 gives 6 -1 =5. So the final result gives all the characters starting from the right of the text, minus 1. The LEN() function is used to extract the total number of characters in B2. The formula that we used in the above method: = RIGHT(B2,LEN(B2)-1) extracts all the characters from cell B2, except for the first character. You can copy this formula to the rest of the cells in the column by double-clicking the fill handle (at the bottom-right corner of the cell). This is assuming that the dollar sign was the first character in the text. You will get the contents of the cell in question, with the dollar sign removed.You can replace B2 with the reference to the first cell from which you want the dollar sign removed. In a new column, type = RIGHT(B2,LEN(B2)-1).If any of the above signs suggest that the cell is actually text, here’s how you can remove the dollar sign: If not, it means your cell does not contain text. If you get the result as TRUE, it means your cell contains the text. You can also double check by typing the formula =istext in an empty cell and passing the reference to your cell.If you click on the cell you can see a small leading apostrophe sign.
![how to clear formatting in excel cells how to clear formatting in excel cells](https://www.basictutorials.in/images/highlight-cells-rules.png)
There would be a green triangle on the top left corner of the cell.Excel always aligns text to the left and numbers to the right within cells The cell would be aligned to the left, instead of right.You can easily tell if this was the case by checking for tell-tale signs: Some people like to add the dollar symbol by converting the cell to text. If the above method did not work, it might be because the dollar symbol was not added by formatting. This should remove the dollar symbol from all the selected cells. Click on the dropdown list next to “ Symbol” and select the “ None” option.Under the Category list, select the ‘Currency’ option.This will open the Format Cells dialog box.Right-click on your selection and click “ Format Cells” from the popup menu.Select the cells containing the dollar signs that you want to remove.Suppose you have a dataset as the one given below, and you want to remove all dollar signs from column B. If the dollar sign was added due to a currency format setting, then you can use this method to remove it. Removing Dollar Sign by Using the Format Cells Dialog Box Removing Dollar Sign by Using the VALUE Function.Removing Dollar Sign by using Find and Replace.Removing Dollar Sign by Using a Formula.Removing Dollar Sign by Using the Format Cells Dialog Box.