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:
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.
- Photo Credit number background image by kuhar from Fotolia.com
How to Do an Apostrophe on the Laptop
Even if your keyboard is broken or missing a key, there are still multiple ways to type a character such as the...
How to Remove Excess Tab Symbols From an Excel Spreadsheet
Microsoft Excel has a lot of options for find and replace; one of the lesser known ones is the ability to delete...
How do I Remove an Apostrophe From a String in Java?
Java's String class has many built-in methods for manipulating the text contained within the string. For removing apostrophes from Strings where they...
How Do I Remove a Word From Cells in Excel?
Large Excel workbooks sometimes contain dozens or even hundreds of occurrences of a specific word. Manually finding and changing each word in...
How to Remove a Named Cell
Microsoft Excel is a spreadsheet application that features graphing tools and calculations. The application contains a grid of cells that are arranged...
How to Use Excel 2010
Excel 2010 is a type of spreadsheet software that is part of the Microsoft Office suite. Excel allows you to organize information,...
How to Clean a String in VBA
As a Visual Basic for Applications programmer, you should be able to remove numbers or characters in strings to display correct information...
How to Use the Apostrophe in Excel
If you have a Microsoft Excel program loaded onto your computer, then you can use it to organize sets of data in...
How to Format Numbers in Excel With Apostrophes
If you are working in a Microsoft Excel spreadsheet and you do not want the Excel program to automatically treat your data...
What Does a Caret Symbol Mean in Microsoft Excel?
The caret (^) symbol usually stands for exponentiation in Microsoft Excel. Exponentiation is a mathematical operation that raises the quantity to a...