Is there a way to combine two cells in to a third cell such that the first
cell's value is left justified and the 2nd cell's value is right justified.
Like a left-tab and a right-tab would do in word.

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

Maybe a VBA function that plops the text into a cell and autofits then
calculates the width then iterates thought adding a space and recalculating
the width until the needed width is reached. This method still has problems
because proportional fonts spacing will not come out exact across multiple
strings of text.

Verbose - I know but there has to be a better way. (I know this square peg
WILL fit in that round hole)

--
Regards,
John