Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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) |