John Keith Wrote:

A1 = "Coffee" {which is left justified in the cell}
B1 = "1010" {which is right Justified in the cell}
C1 = "Coffee 1010" {which does
not
have the physical spaces added, this should be controlled by auto-fit
in the
cell based on the data in the entire column-C} Of course I could use
fixed
font and always make the cell have 50 characters for example... but I
want
this to work with proportional fonts.

Something like... =LeftJust(A1)&RightJust(B1) -or-
=A1&RTabChar&B1

John
=A1&" "&B1
something like this?


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=538622