The one character is CHAR(133)
You can do a Find and replace to substitute all "three dots" to the "one character" or vice versa. You can paste that character
into the dialog box like you did into your post

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Scott" wrote in message ...
|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