Combination of left and right justification in a cell?

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

You could always format two adjacent columns to appear as though they are a single column....
Otherwise I'm not sure there's any way to mix two different types of alignments in a single cell.

What's the purpose?

Tim

"John Keith" <[email protected]> wrote in message news:[email protected]...
> 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