Please don't SHOUT! It is considered to be bad netiquette.
Yes, click on the A or B or ? and then format.

--
Don Guillett
SalesAid Software

"lburg801" wrote in
message ...

IS THERE A WAY TO FORMAT THE WHOLE COLUMN OR DO I HAVE TO CHANGE THE
CELL NUMBERS AND APPLY IT TO EACH CELL IN THE COLUMN?

Search33 Wrote:
You could use a 'helper' column to sort by... for example
A:First_Name1, B:Last_Name1, C:AND, D:First_Name2, E:Last_Name2,
F:SORT

F:=if(isblank(B1),E1,B1) and copy it down the column. This will put
Last_Name1 in F if it exists and Last_Name2 if it does not.
Note: the = sign needs to be at the beggining of the formula

I think this is the easiest way that you won't have to rework the
whole
spreadsheet...again.

"Don Guillett" wrote:

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

...[color=green]

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
IS THERE A WAY TO FORMAT THE WHOLE COLUMN OR DO I HAVE TO CHANGE THE
CELL NUMBERS AND APPLY IT TO EACH CELL IN THE COLUMN?


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