Without too much thought how about a column for the couple and another
column on the SAME row if there are two
Brown, Joe Betty
Brown, Joe Smith, Ann

then you could use
=a2 & " " & b2

--
Don Guillett
SalesAid Software

"lburg801" wrote in
message ...

I'm a Newbie. Church secretary died, no one knows how to use database as
is. I have re-entered data from scratch in new worksheet - all of it!

Because many couples do not share same last name, it was suggested that
I create these columns First_Name1, Last_Name1, AND, (actually a column
containing the conjunction "and") First_Name2, Last_Name2.

This design was based on creating mailing labels and a directory. To
have it work in printing labes, etc, I was to leave Last_Name1 blank if
the couple shared the same last name. A limited test was positive with
data imported by word for mailing labels - or did they export to Word?
- I am so green!.

Since the test, I have added new names to the database. I just did them
all at the bottom of the worksheet assuming I could sort the whole
database alphabetically when done.

I was looking for a way to sort by Last name. Since there are single
members, the column I would have to use is Last_Name1 column - so I'm
sure you are far ahead of me in seeing the flaws in this setup and can
possibly understand my state of panic at this point.

Trudy


--
lburg801
------------------------------------------------------------------------
lburg801's Profile:
http://www.excelforum.com/member.php...o&userid=28338
View this thread: http://www.excelforum.com/showthread...hreadid=479579