software

I have a simple table of state names in one column and city names in the next
column. There are 4 rows that will not sort correctly state then city. I
have cleared and reentered the information, checked cell formatting, and
selected the entire table, but still will not work. Any help
--
chris

Have you checked for leading spaces? That will do what you say. You say
that you re-entered the data but leading spaces is about the only way you
can get what you say. Post back and provide a short list of what you have.
Indicate which ones in your list sort properly and which do not. HTH Otto
quot;chrisquot; gt; wrote in message
...
gt;I have a simple table of state names in one column and city names in the
gt;next
gt; column. There are 4 rows that will not sort correctly state then city. I
gt; have cleared and reentered the information, checked cell formatting, and
gt; selected the entire table, but still will not work. Any help
gt; --
gt; chris
Thanks for replying. Here is a partial list. There are no leading spaces.
You will notice that the first 3 entries of cities in TX are not in order. I
can't even get them to move if I try to sort just a small chunk like this.
Any ideas?

TennesseeMemphis
TennesseeNashville
TexasHarlingen
TexasTexas City
TexasUvalde
Texas Angleton
Texas Aspermont
Texas Austin
Texas Beaumont
Texas Brownsville

--
chrisquot;Otto Moehrbachquot; wrote:

gt; Have you checked for leading spaces? That will do what you say. You say
gt; that you re-entered the data but leading spaces is about the only way you
gt; can get what you say. Post back and provide a short list of what you have.
gt; Indicate which ones in your list sort properly and which do not. HTH Otto
gt; quot;chrisquot; gt; wrote in message
gt; ...
gt; gt;I have a simple table of state names in one column and city names in the
gt; gt;next
gt; gt; column. There are 4 rows that will not sort correctly state then city. I
gt; gt; have cleared and reentered the information, checked cell formatting, and
gt; gt; selected the entire table, but still will not work. Any help
gt; gt; --
gt; gt; chris
gt;
gt;
gt;

How about extra spaces between words? Use the Trim function to take out the
extra spaces. There is a very good reason for this, we just have to find
it. I just copied/pasted the list you had in your message into a new blank
Excel file, and it sorted perfectly. If you wish send me, direct via email,
a small file that demonstrates your problem Make sure the problem is
present in that small file before you send it. My email address
. Remove the quot;nopquot; from this address. HTH Otto
quot;chrisquot; gt; wrote in message
...
gt; Thanks for replying. Here is a partial list. There are no leading
gt; spaces.
gt; You will notice that the first 3 entries of cities in TX are not in order.
gt; I
gt; can't even get them to move if I try to sort just a small chunk like this.
gt; Any ideas?
gt;
gt; Tennessee Memphis
gt; Tennessee Nashville
gt; Texas Harlingen
gt; Texas Texas City
gt; Texas Uvalde
gt; Texas Angleton
gt; Texas Aspermont
gt; Texas Austin
gt; Texas Beaumont
gt; Texas Brownsville
gt;
gt; --
gt; chris
gt;
gt;
gt; quot;Otto Moehrbachquot; wrote:
gt;
gt;gt; Have you checked for leading spaces? That will do what you say. You say
gt;gt; that you re-entered the data but leading spaces is about the only way you
gt;gt; can get what you say. Post back and provide a short list of what you
gt;gt; have.
gt;gt; Indicate which ones in your list sort properly and which do not. HTH
gt;gt; Otto
gt;gt; quot;chrisquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a simple table of state names in one column and city names in the
gt;gt; gt;next
gt;gt; gt; column. There are 4 rows that will not sort correctly state then city.
gt;gt; gt; I
gt;gt; gt; have cleared and reentered the information, checked cell formatting,
gt;gt; gt; and
gt;gt; gt; selected the entire table, but still will not work. Any help
gt;gt; gt; --
gt;gt; gt; chris
gt;gt;
gt;gt;
gt;gt;