Excel 2007 : Removing Apostrophes

**ameyabrid** · 08-30-2011, 11:01 AM

Dear All,

I am trying to remove all apostrophes (') from the data in column B in the attached sheet (for eg Cell B16 has the word - Field's - which should read as - Fields - once the apostrophe is eliminated).

I have tried changing the cell format to text and using the find & replace but it does not detect the apostrophes. Copying this data into another instance of excel and doing the same seems to work, however I need to be able to do this in the same sheet / workbook.

Could anyone please suggest a remedy.

Thanks,

A.

**NBVC** · 08-30-2011, 11:15 AM

It worked for me in Excel 2007 (as your profile indicates) and in Excel 2003. It found and replaced 19 occurences.

**Domski** · 08-30-2011, 11:17 AM

I just did a find/replace and it worked fine.

Dom

**ameyabrid** · 08-30-2011, 11:35 AM

@ NBVC & Domski - Thanks for your quick replies. It might be some setting on my computer which is preventing the detection of the apostrophes (?). I'll look again.

Thanks