Forum Discussion
ccjaime
Mar 05, 2019Copper Contributor
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
- SergeiBaklanDiamond 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.