Re: How can I remove hidden apostrophe in Excel?
- From: "Lori" <lorimer_miller@xxxxxxxxxxx>
- Date: 14 Feb 2007 13:19:34 -0800
You could also try selecting a column and then Data > Text to columns
Finish.
On Feb 14, 6:00 pm, Jim Moberg <JimMob...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Hi,
I have a spread*** of data and a number of the columns have data that is
preceeded by a hidden apostrophe. The apostrophe can only be seen when you
click on the cell. I have looked and can't find a post that addresses this.
Can anyone out there tell me how to remove this. I have tried using the trim
function in conjuction with the clean function and it didn't work. Ack!
.
- Prev by Date: Re: Setting password on work*** in Excel 2000
- Next by Date: Time entered (and handled as data) in simple minutes and seconds.
- Previous by thread: Re: How can I remove hidden apostrophe in Excel?
- Next by thread: Setting password on work*** in Excel 2000
- Index(es):
