Align left and Align right in same row and column?

L

Lostguy

Hello!

In a new workbook, take cell A1 and widen it to 7" long.
Now, is there a way I can align "To:Mom" to the left and the date to
the right in the same row and column?

So for A1, it would look
like"To:Mom
Jan 11, 2009"??

I only want to use one column.And without VBA.

Maybe, if you can't do a flush left and right in the same line, is
there a code for tab similar to CHAR (10)? I was thinking something
like ="To:Mom"&CHAR(tab)&CHAR(tab)&NOW

??

Thanks!

VR/

Lost
 
J

John W. Vinson

In a new workbook, take cell A1 and widen it to 7" long.
Now, is there a way I can align "To:Mom" to the left and the date to
the right in the same row and column?
Click to expand...

Please ask your question in a newsgroup supporting Excel; this group is for a
different program, Microsoft Access. The webpage can be confusing and may have
misled you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Align left and Align right in the same cell 2
Right Aligned TOC Numbers 1
Right-aligning a partial line of text? 4
Sheet Right Aligned 5
Excel 2007 need to get all data in a column to be number format 1
sum numbers in cell string array 6
Numbered Procedural Steps Alignment 1
two tables in the same row 6

Top