Abstract

If you need to condense a two-column table or a two-items list into one column, you can use a monospaced font (Courier New, Lucida Sans Typewrite) and a simple worksheet formula:

left_align_and_right_align_in_one_column

If you use an English language version of Excel, use the number format #,##0.00 and this formula in cell D8:

=$A8&REPT(" “,$C$9+$C$11+1-LEN($A8)-LEN(TEXT($B8,$C$13)))&TEXT($B8,$C$13)

Download

Please read my Disclaimer.

left_align_and_right_align_in_one_column.xslx [11 KB Excel file, open and use at your own risk]