Hi,

I weekly receive a spreadsheet that's be created from a database export and
where there is no data (text or numbers), the cell contains an apostrophe.

What I would like to do, is to check whether the cell only contains and
apostrophe and if so, remove it. The range of data varies from week to week
so I'm guessing I need to select the range or somehow check the area used
and run some VBA code.

I can recall something previously on the MS forums but searching doesn't
find anything.

Thanks in advance. Rob