Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Texas, USA
    Posts
    374
    Thanks
    1
    Thanked 0 Times in 0 Posts

    How to delete the apostrophe in a cell value? (2002)

    I need to get rid of the Apostrophe which is the prefix of value of every cell in a datasheet. I tried to use the Find and Replace feature. Unfortunatly, it seems that Excel could not recognize the ' I entered as a search value.

  2. #2
    Lounger
    Join Date
    Oct 2001
    Location
    Isleworth, Gtr London, England
    Posts
    28
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: How to delete the apostrophe in a cell value? (2002)

    It sounds as if you've got Transition Formula entry switched on, which puts apostrophes in the cell formulae automatically.

    Use menu option Tools/Options and select Tab Transition, and switch off any Transition check boxes.

    Hope that helps.
    Glenn.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: How to delete the apostrophe in a cell value? (2002)

    The the apostrophe to which you refer has a special meaning to excel, and that is to treat the cell entry as text. The following procedure should remove the apostrophe and set all numeric characters to numbers.

    Select a blank cell and copy it to the clipboard. Then select the cells with the apostrophe and Paste Special and under the Operation section of the options select Add. That should help.

    Andrew C

  4. #4
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to delete the apostrophe in a cell value? (2002)

    Nice, Andrew.
    Very nice!

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Texas, USA
    Posts
    374
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: How to delete the apostrophe in a cell value? (2002)

    Andrew, thank you very much, very very much.

  6. #6
    New Lounger
    Join Date
    Feb 2002
    Location
    Melbourne, Australia
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to delete the apostrophe in a cell value? (2002)

    Thanks heaps Andrew!
    I was just browsing before I lodged my own query on this same problem.

    Have a good one!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •