Forum Discussion

ccjaime's avatar
ccjaime
Copper Contributor
Mar 05, 2019

How to get rid of quotations between numbers

How can I get rid of or clear of equal sign and quotations between numbers in a cell or range of cells.

 

Thank you,

="""123456"""

 

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    If Ctrl+H on you range and Replace All quotation marks on nothing you will convert your texts to numbers. Equal sign affects nothing, not necessary to remove it. But you may Ctrl+H on it as well.

Resources