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

Delete blank columns in excel for mac