Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric? | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
error: "invalid character in text conent" How do I open this file | Excel Discussion (Misc queries) |