How to delete the apostrophe in a cell value? (2002)

Topic

New Reply

I need to get rid of the Apostrophe which is the prefix of value of every cell in a datasheet. I tried to use the Find and Replace feature. Unfortunatly, it seems that Excel could not recognize the ‘ I entered as a search value.

Reply | Quote

Replies

It sounds as if you’ve got Transition Formula entry switched on, which puts apostrophes in the cell formulae automatically.

Use menu option Tools/Options and select Tab Transition, and switch off any Transition check boxes.

Hope that helps.
Glenn.

Reply | Quote

The the apostrophe to which you refer has a special meaning to excel, and that is to treat the cell entry as text. The following procedure should remove the apostrophe and set all numeric characters to numbers.

Select a blank cell and copy it to the clipboard. Then select the cells with the apostrophe and Paste Special and under the Operation section of the options select Add. That should help.

Andrew C

Reply | Quote

Nice, Andrew.
Very nice!

Reply | Quote

Andrew, thank you very much, very very much.

Reply | Quote

Thanks heaps Andrew!
I was just browsing before I lodged my own query on this same problem.

Have a good one!

Reply | Quote