Align left and Align right in the same cell

[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

 

[ebloch]

Cell enter
A1 Mom
B1 the date (if today use <Ctrl>+ format the cell as you want.
==> If you type it as text then you do not need C1
C1 =CONCATENATE(CHOOSE(MONTH(B1),"Jan","Feb")," ",DAY(B1),", ",YEAR(B1))
==> Add all of the months as you want them to appear
D1 *** spaces (as text)
==> *** is a number depending on width you want, text style, and
size.
A2 =CONCATENATE("To: ",A1,LEFT(D1,(LEN(D1)-4-LEN(A1)-LEN(C1)),C1)
==> combine A2 thru D2 and have it show your full line.

It is brute force but works and you only have to enter "Mom" and date to
begin.

Eric

 

[Pete_UK]

You could put this formula in A1:

="To:Mom"&REPT(" ",30)&TEXT(TODAY(),"mmm dd, yyy")

and it will give you this:

To Mom Jan 12, 2009

Just change the 30 to give you the separation that you need.

Hope this helps.

Pete