Combination of left and right justification in a cell?

[John Keith]

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)

 

[davesexcel]

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?

 

[Tim Williams]

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