what are the "..." character

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Go to
<Tools> <AutoCorrect>
And delete the 3 dot entry you'll find there, near the top.

I forget exactly what they call this.
 
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

|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
 
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 edit>replace 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
 
This macro works also to replace the 133 with 3 46's(which are periods)

Sub Remove_Ellipsis()
With Selection 'select all cells, those without ellipsis are ignored
..Replace What:=Chr(133), Replacement:=Chr(46) & Chr(46) & Chr(46), _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False

End With
End Sub


Gord
 
Back
Top