One way,

Put a zero in a cell and copy it.
select your data with apostrophes and then
Edit|Pastespecial
Select add
Click OK

Mike

"Colin Hayes" wrote:



Hi

All the entries to my cells in column A seem to have a ' symbol at the
start of them.

A formula I'm using in column B is failing because of this. When I
manually remove the ' from the formula box , my formula works.

Does anyone know how to strip out the leading ' from all the cells , and
leave all the real data intact?

Thanks.