| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I ignore numbers and sort only text in an Excel column?
I have an Excel spreadsheet that contains 4,000 names and addresses of local
registered voters. The addresses are listed with the house number and street (102 Oak Ave., eg) I want to sort the data so that all the people living on the same street are together. Is there any way to do that in Excel, and if not, is it possible to export the spreadsheet to Access and do it there. I have tried several times to read the spreadsheet in as an Access data base, but no luck. But I don't know if it is possible to do that even if I could get the data base set up. Anyone got any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort text as numbers | Excel Discussion (Misc queries) | |||
| How do I format a column in alpha order? | New Users to Excel | |||
| Excel won't sort numbers correctly | Excel Discussion (Misc queries) | |||
| How can I sort by numbers and not text? | Excel Worksheet Functions | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
