Sorting by ignoring numbers
Posted by Francyn on February 22, 2001 8:37 AM
I have a list of house addresses that I want to sort by street and not house number. How do I do a sort ignoring numbers? If too complicated, how do I create two separate columns, 1 for house number, 1 for street name?
Posted by Faster on February 22, 2001 9:10 AM
You can break your column to two columns by using
Data/Text to Columns from the menu. Use space as
delimiter.
