First, I don't see the attachment. I don't read the newsgroups through
excelforum.

Second, try this:
=len(a1)
change a1 to point at a cell with only that apostrophe.

If you see 0, you can try this:

Select the range to fix
edit|Replace
what: (leave blank)
with: $$$$$
replace all

Then with that range still selected
edit|Replace
what: $$$$$
with: (leave blank)
replace all

All the cells with a single apostrophe should be cleared.



jdelcour wrote:

Thanks for your reply Dave. Unfortunately, the transition keys were
already deselected.

Even if there are no data present in the cells, the commas or
apostrophes still appear. The only way I found to get rid of them is to
physically delete the cells. Any clue ? - I have attached a copy of the
workbook

--
jdelcour
------------------------------------------------------------------------
jdelcour's Profile: http://www.excelforum.com/member.php...o&userid=36496
View this thread: http://www.excelforum.com/showthread...hreadid=562527

--

Dave Peterson