I am not an expert and I am not sure that this is a proper fix for your
problem but it works.

At the top of the column that will contain your names, click to highlight
the whole column, then right click and chose format cells, Alignment, on
Horizontal select Distributed(Indent). Go back and right click the
highlighted column again and select "column width" and set it for the
longest name you expect to have (this can be changed if you find you have
longer names later).
The column will adjust for the shorter names but it will wrap for longer
ones.
Just another user of Excel 2003.
Pat
--


Living life is like drawing without an eraser!

"Sloth" wrote in message
...
I am trying to align the first names to the left of the cell and the last
names to the right (don't ask me why). I know one way but it requires a
custom number format for each entry. Is the another method anyone here
can
suggest to get the same thing without using a custom number format.

Here's how I currently do it.
Say I want "Patrick Stewart" to look like this...
Patrick Stewart
I enter Patrick in the cell and then apply the following custom number
format..
@* "Stewart"
and align the cell to the left.
the "* " tells excel to enter as many spaces as it can to fill the cell.

This method works if I have one or two names in the list I want to do this
with, but it gets cumbersome after more than a handful.