Remove leading apostrophe from numbers with VBA code Remove leading apostrophe from numbers with Text to Column Remove leading apostrophe from numbers with paste as values To remove them one by one will spend much time, here, I will talk about some quick tricks for solving this problem. And now, you want to remove the leading apostrophe from the cell value. Supposing you have a list of numbers which are preceded by a hidden apostrophe, and the apostrophe only be seen in the Formula bar when you select the cell as following screenshot.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |