The first of your example has an ellipsis which is 3 dots as one character.

The other has plain old periods.

Ellipsis is CHAR(133)

You could do an editreplace on the ellipsis

Replace what: Alt + 0133(on numpad)

Replace with: ...(3 periods)

Or go the other way round if you choose.


Gord Dibben MS Excel MVP


On Wed, 17 Oct 2007 12:20:02 -0700, Scott
wrote:

I am trying to work with some data in a worksheet that someone generated.
Some of the cells have text like "X...Y". The problem is in some of the
cells the "..." are periods and you can cursor to each one but in other cells
the "..." acts like a tab where the cursor goes from X directly to Y without
going throught each "...". What are these and how can I get make them like 3
periods? Or how can I make all the "..." the same? Below is an example of
each (take your cursor and right arrow along each one).

X...Y

X…Y