I have a worksheet with a column of data that is in this format:
'12345
Whenever I operate on it formulaically it retains the tick mark. It cannot be cell formatted out.
I don't want to co thru the hassle of saving it as .txt file and then re-importing into my Excel workbook, making sure to delimit it and import as text, and finally copy paste special values over existing data, although we all know this method does work.
Isn't there a cleaner or easier way to deal with this cleansing?
btw, this is a text value string, not a date integer.
![Stick out tongue :p :p](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
'12345
Whenever I operate on it formulaically it retains the tick mark. It cannot be cell formatted out.
I don't want to co thru the hassle of saving it as .txt file and then re-importing into my Excel workbook, making sure to delimit it and import as text, and finally copy paste special values over existing data, although we all know this method does work.
Isn't there a cleaner or easier way to deal with this cleansing?
btw, this is a text value string, not a date integer.