|
new user needs help with programing
it's a spreadsheet of names and addresses
the addresses column has both the street number and address. like 1233 LAKE ST What I would like to do, is sort them on the street name AND THEN the number so I would have the sheet list them in order of street name and then order of number such as 1233 Lake St 1234 Lake St 1235 Lake St etc. so how do I split the columns automatically so that it will sort by the name alphabetically and then the number numerically please and thank you... -- ----------------------------------------------------- Lawyer to witness: Now doctor, isn't it true that when a person dies in his sleep, he doesn't know about it until the next morning? ----------------------------------------------------- Bill H. in Chicagoland webcams at http://76.16.160.118:8080 weather at http://hhweather.webhop.org web blog at http://vote4billheinzinger.blogsport.com -- ----------------------------------------------------- Things are more like they are now than they ever were before. ----------------------------------------------------- Bill H. in Chicagoland webcams at http://76.16.160.118:8080 weather at http://hhweather.webhop.org web blog at http://vote4billheinzinger.blogsport.com |
new user needs help with programing
How do I find the "New Users"? I am interested in the answer myself but
cannot find the forum. -- Best wishes, Jim "Don Guillett" wrote: See reply in "new users". Pls learn to post in ONE group only. -- Don Guillett SalesAid Software "FireBrick" wrote in message ... it's a spreadsheet of names and addresses the addresses column has both the street number and address. like 1233 LAKE ST What I would like to do, is sort them on the street name AND THEN the number so I would have the sheet list them in order of street name and then order of number such as 1233 Lake St 1234 Lake St 1235 Lake St etc. so how do I split the columns automatically so that it will sort by the name alphabetically and then the number numerically please and thank you... -- ----------------------------------------------------- Lawyer to witness: Now doctor, isn't it true that when a person dies in his sleep, he doesn't know about it until the next morning? ----------------------------------------------------- Bill H. in Chicagoland webcams at http://76.16.160.118:8080 weather at http://hhweather.webhop.org web blog at http://vote4billheinzinger.blogsport.com -- ----------------------------------------------------- Things are more like they are now than they ever were before. ----------------------------------------------------- Bill H. in Chicagoland webcams at http://76.16.160.118:8080 weather at http://hhweather.webhop.org web blog at http://vote4billheinzinger.blogsport.com |
new user needs help with programing
you are now on
microsoft.public.excel.programming so microsoft.public.excel.newusers -- Don Guillett SalesAid Software "Jim Jackson" wrote in message ... How do I find the "New Users"? I am interested in the answer myself but cannot find the forum. -- Best wishes, Jim "Don Guillett" wrote: See reply in "new users". Pls learn to post in ONE group only. -- Don Guillett SalesAid Software "FireBrick" wrote in message ... it's a spreadsheet of names and addresses the addresses column has both the street number and address. like 1233 LAKE ST What I would like to do, is sort them on the street name AND THEN the number so I would have the sheet list them in order of street name and then order of number such as 1233 Lake St 1234 Lake St 1235 Lake St etc. so how do I split the columns automatically so that it will sort by the name alphabetically and then the number numerically please and thank you... -- ----------------------------------------------------- Lawyer to witness: Now doctor, isn't it true that when a person dies in his sleep, he doesn't know about it until the next morning? ----------------------------------------------------- Bill H. in Chicagoland webcams at http://76.16.160.118:8080 weather at http://hhweather.webhop.org web blog at http://vote4billheinzinger.blogsport.com -- ----------------------------------------------------- Things are more like they are now than they ever were before. ----------------------------------------------------- Bill H. in Chicagoland webcams at http://76.16.160.118:8080 weather at http://hhweather.webhop.org web blog at http://vote4billheinzinger.blogsport.com |
new user needs help with programing
Why do we try to make the simple things so difficult? :) I feel like the
fellow who reported on his trip to the doctor, saying "They x-rayed my head but couldn't find anything." -- Best wishes, Jim "Don Guillett" wrote: you are now on microsoft.public.excel.programming so microsoft.public.excel.newusers -- Don Guillett SalesAid Software "Jim Jackson" wrote in message ... How do I find the "New Users"? I am interested in the answer myself but cannot find the forum. -- Best wishes, Jim "Don Guillett" wrote: See reply in "new users". Pls learn to post in ONE group only. -- Don Guillett SalesAid Software "FireBrick" wrote in message ... it's a spreadsheet of names and addresses the addresses column has both the street number and address. like 1233 LAKE ST What I would like to do, is sort them on the street name AND THEN the number so I would have the sheet list them in order of street name and then order of number such as 1233 Lake St 1234 Lake St 1235 Lake St etc. so how do I split the columns automatically so that it will sort by the name alphabetically and then the number numerically please and thank you... -- ----------------------------------------------------- Lawyer to witness: Now doctor, isn't it true that when a person dies in his sleep, he doesn't know about it until the next morning? ----------------------------------------------------- Bill H. in Chicagoland webcams at http://76.16.160.118:8080 weather at http://hhweather.webhop.org web blog at http://vote4billheinzinger.blogsport.com -- ----------------------------------------------------- Things are more like they are now than they ever were before. ----------------------------------------------------- Bill H. in Chicagoland webcams at http://76.16.160.118:8080 weather at http://hhweather.webhop.org web blog at http://vote4billheinzinger.blogsport.com |
| All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com