Share via

Deleting an Apostrophe

Anonymous
2020-05-06T18:58:46+00:00

I am working with a spreadsheet that was converted from CSV to excel.  In one column is a numerical number with an apostrophe in the front of the number. I need the apostrophe removed. I have tried text to columns and it doesn't work.

Tom

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-05-06T19:35:54+00:00

    Put a 0 in an unused cell and copy it.

    Select your 'numbers-with-an-apostrophe-prefix' and right-click, Paste Special.

    On the Paste Special dialog, choose Paste, Values and Operation, Add then click OK.

    BTW, if your 'numerical numbers' are longer than 15 digits, you will lose mathematical precision due to Excel's 15 significant digit floating point precision limitation. See Floating-point arithmetic may give inaccurate results in Excel.

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2020-05-07T05:10:43+00:00

    In Excel, the Text to Column function also can help you to solve this task.

    1. Select the data range that you want to remove the leading apostrophe.

    2. Then click Data > Text to Column, and in the Convert Text to Columns Wizard, clickFinish button directly, see screenshot: 

    3. And now, you will find all the leading apostrophes have been removed from the numbers

     Source.

    1 person found this answer helpful.
    0 comments