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

--
acarri
-----------------------------------------------------------------------
acarril's Profile: http://www.excelforum.com/member.php...fo&userid=1002
View this thread: http://www.excelforum.com/showthread.php?threadid=27741