Mar 05 2019 01:19 PM
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"""
Mar 05 2019 02:13 PM
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.