what are the "..." character
 

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

what are the "..." character
 

Go to
<Tools <AutoCorrect
And delete the 3 dot entry you'll find there, near the top.

I forget exactly what they call this.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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

what are the "..." character
 

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

what are the "..." character
 

CHAR(133) ... is call "ellipsis"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"RagDyer" wrote in message
...
Go to
<Tools <AutoCorrect
And delete the 3 dot entry you'll find there, near the top.

I forget exactly what they call this.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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

what are the "..." character
 

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

what are the "..." character
 

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

On Wed, 17 Oct 2007 12:55:13 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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

what are the "..." character
 

Thanks ... I use it all the time.<g
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bernard Liengme" wrote in message
...
CHAR(133) ... is call "ellipsis"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"RagDyer" wrote in message
...
Go to
<Tools <AutoCorrect
And delete the 3 dot entry you'll find there, near the top.

I forget exactly what they call this.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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