So you have 2 separete columns, one with the city name already extracted and
matching to the corresponding address on every row?

If this is the case you can do a Data-Sort and just sort on the city name
column. Excel will copy the respective address record to correspond to the
sort.
--
Regards,

Dave


"Animesh" wrote:

I have two sets of data, one column containing the whole address and one
containing only the city names. I need to arrange the data as per the city
names. Can i do it in Excel? I kinda tried using the Find( ) command like
isnumber(find(text),,) but it only works for a cell and not for an array. Can
anyone help??