I want to make a cell that contains both left and right justified text. Can
that be done?

I.E. A1 = "Item Desc 1" ; B1 = "1001"
I want to make a formula so that in C1 the result will be;

First 30 characters is A1 left justified
Character 31-35 is B1 right justified.

=A1&REPT(" ",30-LEN(A1))&B1 will work only if I switch to a non
proportional font. But I would prefer not to swap the font.

Maybe something like a chr(#) that will insert a right tab?

any ideas?
--
Regards,
John