Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2007

Tip: Looking for answers? Try searching our database.

Format Cells, Text Alignment, Distributed

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JEFF - 16 Jun 2007 20:37 GMT
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 - 16 Jun 2007 22:07 GMT
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.

> Greetings,
>
[quoted text clipped - 14 lines]
> Thanks in advance.
> Jeff Willis
Dave Peterson - 16 Jun 2007 22:58 GMT
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>.

> My post wrapped funny.  I want the text formatting to look something like
> this:
[quoted text clipped - 21 lines]
> > Thanks in advance.
> > Jeff Willis

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.