Removing Dollar Sign by using Find and Replace


Staff member
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.
Here’s how this method works:
  1. Select the cells containing the dollar signs that you want to remove.
  2. From the ‘Editing’ group, under the Home Tab, click on ‘Find and Select’ and click ‘Replace’ from the drop-down menu. Alternatively, you can just press CTRL+H from your keyboard.
  3. This will open the ‘Find and Replace’ dialog box. In the ‘Find’ field, enter [imath]. (If there’s a space following the dollar sign, then enter[/imath] followed by a space character).
  4. Leave the ‘Replace with’ field empty. This will make sure that all the dollar signs get replaced with a blank.
  5. Click on the ‘Replace All’ button.