Sorting data/linking cells

[Peter Atherton]

Hello

Excel sorts data in rows. This is the recomended way to
store details of one record. Then it is easy to sort the
information based on the columns you want to sort.

A records information stored on one row can be used with
Word for mail merging.

To sort the records as you have them, insert a new column
A and enter numbers for each record so you would need the
same number in rows A2 to A3. to keep the record together.

I would advise you to rearrange you data and keep it on
one line per record. If you have a lot of data someone
could write a macro to do this for you.

Regards
Peter

delete removethis when replying

-----Original Message-----
Hi! Total novice at Excel but here's the story: Trying to sort the following format:
Name, Regional Name, Address (in three cells ex. D2, D3, D4, etc), Telephone Number
I leave a blank row in between each address for easy

reading. When I attempt to sort by Regional Name, all
that sorts is the top line of the address leaving cells D3
and D4 behind, etc. Is there some way to line the
address cells together so theywill sort together?? Or
should I have formatted this whole deal differently to
begin with? Thanks!!