help with sorting

  • Thread starter Thread starter acarril
  • Start date Start date
A

acarril

i import multiple data (500 rows or more) and it comes across a
follows:
first name last name
address 1
address 2 (not always present)
city, state zip

there are no empty rows in between each row and the data in each row i
only in 1 cell. I am trying to sort by either city or zip but maintai
the grouping intact. any help would be greatly appreciate
 
Are all zip codes 5 numbers? (as opposed to a 9 digit zip code)

Just to verify
City, state zip

is all in one cell in column A.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top