How to Remove the Apostrophe Prefix From Excel

Save

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.

  • 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:

    clean(RANGE)

    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.

Related Searches

References

  • Photo Credit number background image by kuhar from Fotolia.com
Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!