The Microsoft Excel software uses the apostrophe character to indicate that a literal value, or string literal, is entered into the cell. For instance, if you type "1+1" into an Excel cell, the result is displayed as "2." To display the actual text "1+1," you place an apostrophe as the first character. The apostrophe is also used when importing content into an Excel spreadsheet. If you wish to remove the apostrophe from the cell, do so either manually or using the internal "clean()" function.
- Skill level:
Other People Are Reading
Open your Excel spreadsheet. Click the cell in the spreadsheet that contains the apostrophe.
Remove the apostrophe from the text box at the top of the Excel spreadsheet. Press "Enter" to save your settings. The apostrophe is removed, and the Excel cell calculates the data instead of displaying a literal.
Enter the "clean" function in an empty cell to remove an apostrophe from multiple cells. Use the following code in the empty cell:
Replace "RANGE" with the range of cells you want to edit. For instance, if you want to remove the apostrophes in the "A" column, enter "clean(A:A)" into a blank cell.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for