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.