Concatenate Cells with 1st set of Cell text left justified and 2nd set right justified

Is it possible to combine 2 cells containing text of varying length into a text string within a cell with the text LEFT justified, then repeat the same cell combination into another text string within the SAME cell with the 2nd text string RIGHT justified with the space between the 2 text strings absorbing the varying space due to the varied length of text from my original cells.

I am trying to essentially create 2 semi-identical columns on a printed label so that I can cut the label in half and use both halves with the alignment of the right half of the label being fairly consistent if not even.

The formula I am using now with a static about of space padded in:

Formula:

Formula:

Please Login or Register  to view this content.

Thanks,

Steve Brosnan

File didn't upload with original post (or at least I can't see it)

Thanks for taking a look!

Steve Brosnan

I am unable to split combined cell because the label printer (only prints labels) takes the 4 Excel cells that I select horizontally and prints them as 4 rows on the label. Splitting them causes 5 rows of data on my labels instead of 4. (and my text to be smaller).

Thanks though. Also your method of pulling my data to the cells is much more elegant than the way I did it and I will be using that in the future as I need to repeat this process for 4 additional workbooks.