Format Cells, Text Alignment, Distributed

[JEFF]

Greetings,

I have a cell that I need to format so that it is justified but I need to
control where the text breaks within the cell. For example, I have in cell
A1 "Name: Jeff Willis Date: 6/16/2007". The cell width is fairly wide and I
would like to format the cells Horizontal Text Alignment to Distributed.

Is there a way to not make the cell distribute the text evenly? For
example, can I embed a tab charactor or some other workaround between the
's' in Willis and the 'D' in Date to make span something like this

Name: Jeff Willis
Date: 6/16/2007

Is there another way to achieve this using cell formatting?

Thanks in advance.
Jeff Willis

 

[JEFF]

My post wrapped funny. I want the text formatting to look something like
this:

|Name: Jeff Willis Date: 6/16/2007|

Where the vertical bars are the left and right edge of the cell.

 

[Dave Peterson]

There's no single format that will accomplish what you want.

In fact, I'd recommend that you put your data in two cells. And use Name and
Date as the header for those columns. It may not look as nice, but you'll find
that you can do more things more easily with the data split this way. (It may
look nicer than you think!)

If you really, really, really want (I wouldn't!), you could give each cell a
custom format.

You only type the date in the cell and have the formatting add the text you
want.

I put 6/16/2007 in A1 and gave it this custom format:
"Name: Jeff Willis"* "Date:" mm/dd/yyyy

The value in the cell is still the date. But the cell's text (what it shows) is
what you want.

The asterisk in the custom format string means to use the next character as a
filler when the cell's column width is extended.

Please don't do this <vbg>.