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.

The only thing I can think of is inserting enough blanks between the name and
the number to total up to the cell width

"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.

I initially tried that, but most fonts do not have an even character spacing
i.e. the default Times New Roman, so the employee numbers do not align
correctly on the right hand side.

The ones that do have even characte rspacing i.e. courrier new, lucendia
typewriter, overflow the cell size, or have to be sized so small that reading
is difficult when printed. I can't adjust the cell size, or I would do that.
I also can not think of any other even spaced fonts that will be of an
easily readable size.

Thanks for the reply.

"Sheeloo" wrote:

The only thing I can think of is inserting enough blanks between the name and
the number to total up to the cell width

"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.

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.

Two suggestions:
1) Get a new boss!
2) For your printing, create two additional columns, one with the
name, the other with the employee number. You could hide them when
not printing, or delete after the printing.

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.

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.