Clear cells containing Ellipse

[TheRobsterUK]

I have a spreadsheet with a large table of data (values only no formulas). Whoever programmed it, they decided that cells with irrelavant entries should display three dots, i.e. "...". Problem is now need to clear these cells (so they are truly blank) but some of them have been auto-corrected in to ellipses and some have not. I wrote the following code:

Please Login or Register  to view this content.

This is fine for the three dots that are just three dots, but for the ones that were auto-corrected to ellipses it doesn't work. How do I amend the code so that it clears the cells that are three dots and the ellipses too?

Many thanks
-Rob

[XmisterIS]

The ellipsis is unicode character 2026 and decimal code 133 in extended ascii ...

... so at a guess, the following code might fix it:

Please Login or Register  to view this content.

[TheRobsterUK]

Works perfectly! Brilliant, thanks! :D