Hi Connull,

Copy a blank cell
Select the cells with the offending initial apostrophe
Edit | Paste Special | Check "Value" and "Add" | OK

Perhaps counter-intuitively, this works on text values.

---
Regards,
Norman



"Connull" <Connull@discussions.microsoft.com> wrote in message
news:32E8EED5-E5DA-447B-9AD1-C95C1B6BFB02@microsoft.com...
> How can I remove the apostrophe (') from the text values in my
> spreadsheet. I
> need to use this spreadsheet to import data into another program which
> then
> gives errors due to the (')