SU123 - Great idea, thanks. It works great if you have two entries in the
cell...
Dave - Hiding the extra columns after printing is also a good idea. You can
record a MACRO to hide/unhide and print to save effort. Also you should
convince your boss. He might have some concern which you need to address. He
is probably concerned with employee name, by mistake, getting associated with
wrong id in case you add or delete a cell


"SU123" wrote:

you can try this. Format the cell to be fully justifyied and after you have
typed in your info press alt+enter, that should work

i.e. format - justified
A Smith 1234 '[atl enter] enter


"Dave Bennett, JSF, VDOT, Virginia" wrote:

I am trying to figure out how to do an unusual justification of text in a
cell.

I have a personnel roster that lists an employee's name and employee number
in the same cell; the boss wants it this way so I can not seperate the name
and employee number.

I want to have the empoyee name justified to the left border of the cell and
the employee number justified to the right border of the cell, so that when
the sheet is printed, everything lines up nice and neat.

Is there a way to do this in Excell? I know that in Word, you can do this,
but I can not figure it out in excel.

Any information anyone can provide is greatly appreciated.