I have an Excel spreadsheet with a column of 825 numbers. These numbers were
put in with the preceding apostrophe so Excel recognizes the numbers as text.
The spreadsheet was probably created with an older version of Excel.
I need to get the apostrophes (') out of the cells as I have to import the
whole spreadsheet into a certain program, which cannot read the symbol, and
thus the import fails. Formatting the cells to Text does not work, nor does
General, as the ' was typed into the cells. I tried to use Find and Replace,
but that didn't work for me.
Is there a way to maybe use a formula to get only the apostrophe out of the
825 cells?
Any help will be greatly appreciated.