 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2007new user needs help
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...  Signature----------------------------------------------------- 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 Have you looked in the help index for SORT SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > it's a spreadsheet of names and addresses > the addresses column has both the street number and address. [quoted text clipped - 13 lines] > > please and thank you... To split the columns go to Date>>Text to Columns. Next step depends on how the info was entered if you can use fixed with or not. If not select delimited>>space>>finish. Now you will have to concatenate the address back together with spaces. Not fun, but the only way I know. SignatureMike Q. > it's a spreadsheet of names and addresses > the addresses column has both the street number and address. [quoted text clipped - 13 lines] > > please and thank you... If your data is as simple as the example, you could use Data>Text to Columns to split the number away from the street name. But I'll bet it is more complicated than you show. Post a real example if of the more complicated type. Gord Dibben MS Excel MVP >it's a spreadsheet of names and addresses >the addresses column has both the street number and address. [quoted text clipped - 13 lines] > >please and thank you... learning on the fly here that worked, thank you guys. sorry I didn't know how to post the question properly. > If your data is as simple as the example, you could use Data>Text to > Columns to [quoted text clipped - 25 lines] >> >>please and thank you... Thanks Just one more question How do I get it to do one side of the street and then the other I mean, say take all even numbered addresses and then all odd numbered. That's far past my ability right now... > If your data is as simple as the example, you could use Data>Text to > Columns to [quoted text clipped - 25 lines] >> >>please and thank you... If the numeric address is in column A, starting in row 2. Paste this formula in row 2 of an empty column. =MOD(A2,2) Now drag the formula down. Even is 0, Odd is 1. Use Data>>Filter to show odds or evens. SignatureMike Q. > Thanks > Just one more question [quoted text clipped - 32 lines] > >> > >>please and thank you... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.