Remove the apostrophe in cell text values in Excel

Remove the apostrophe (') in Excel cell text values
How can I remove the apostrophe (') from the text values in my spreadsheet. I
need to use this spreadsheet to import data into another program which then
gives errors due to the (')


Use the replace feature in the menu of Excel. In Find What enter the apostrophe '   and the replace it with a space or any character you want.

remove apostrophe in excel

 Other excel answers



You can find similar Excel Questions and Answer hereunder

1) How can I enter a cent symbol in a cell?

2) Can I add a small chart to Table data to make it visually appealing and easy to interpret?

3) How can I update a listbox based on data in a list using VBA?

4) How can I have text autocomplete by typing in a short code for the text?

5) Converting numbers stored as text to numbers via macro in Excel

6) How can I identify all cells with Data Validation in my WorkSheet?

7) How can i filter multiple columns simultaneously in Excel

8) How can I avoid updates to cell values during macro execution?

9) How to see to which cells a cell is connected or used by. How to see the precedents of a cell

10) How can I quickly remove all blank cells in a data range?


Here the previous and next chapter