Remove Apostrophe or Text Indicator

This post will guide you how to remove the apostrophe (‘) from the text values in your worksheet in excel. How do I remove text indicator from a text string in a cell in excel. How to use an excel formula to remove text indicator quickly. How to remove leading Apostrophe from a text value in a cell.

Remove Apostrophe with Excel Formula


If you want to remove the text indicator (‘) or the leading Apostrophe from a text string in one cell, you can create a formula based on the VALUE function.Just like this:

=VALUE(B1)

You just need to type this formula into the formula box of the cell C1, then press Enter key in your keyboard. And drag the AutoFill Handler over other cells to apply this formula.

Let’s see the result:

remove text indicator1

 

Remove Apostrophe with Text to Columns Function


You can also use the Text to Columns function to remove the text indicator from text values in one cell, just do the following steps:

#1 select the cells that you want to remove the Apostrophe or text indicator, such as: B1:B3

#2 go to DATA tab, click Text to Columns command under Data Tools group. And the Convert Text to Columns Wizard dialog will appear.

remove text indicator2

#3 select the Delimited radio button, and then click Finish button.

remove text indicator3

#4 you will see the text indicators have been removed.

remove text indicator4

 Related Functions


  • Excel VALUE function
    The Excel VALUE function converts a text value that represents a number to a numeric value.The syntax of the VALUE function is as below:= VALUE  (text)…

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar