TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
Thanks to Rachael Lininger for the following solution:
> I don't have an exported spreadsheet, but I typed some text
> in a cell. I put an
> apostrophe in the front and one in the middle (to make sure
> you wouldn't lose
> any wanted apostrophes). The cell itself doesn't show the
> apostrophe, only the
> formula bar, so in my copy it's reading as a nonprinting
> character. A copy/
> paste-special with values only into a new column might do it.
>
> Also, =CLEAN(cell) works. Then again copy the column and
> paste special into a new column with "values only."
>
> HTH,
>
> Rachael
>
> > "Goldstein, Dan" wrote:
> >
> >I've got an Excel 2000 spreadsheet that was exported from
> > Access 2000 in Win XP.
> >
> >*Every* cell with imported text begins with an apostrophe,
> > which is needed
> >only for numbers-as-text. I'd like to remove the unneeded
> > apostrophes...
