Align left and Align right in the same cell

  • Thread starter Thread starter Lostguy
  • Start date Start date
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
 
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
 
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
 
Back
Top