I need a macro, or a function to combine 2 columns of data into one column
WITHOUT losing the text-justification of each. See below.

what i have: 1st column is left-justified text. 2nd column is
right-justified text.

[john ][ smith]
[sam ][ williams]
[antwane][ carlson]

what i need in each cell, which is no larger than a cell width of 88.14 or
622pixels :

[john smith]
[sam williams]
[antwane carlson]


if i concatenate, i get the below which is not what i need:
[john smith ]
[sam williams ]
[antwane carlson ]


can i put another formula in to justify all last names to the right in one
cell? maybe take the difference between the number of text that can fit into
cell width of 88.14, and the total amount of text from both cells and space
that amount in between the result?? I don't really know...maybe overthinking
it.

Please help
thx!!