Concatenate cells into a tabular formatted cell - fix the length of a text field when concatenated

[steveTu]

Is it possible to concatenate cells into a cell in a formatted way?

I have a spreadsheet with a few columns of different types (ie text, date, currency) and I want to be able to create a single cell with the text set to a certain length, followed by a couple of currency fields.
IE I want -
text of ‘n’ chars, £#,##0.00,£#,##0.00
so that column across all the rows has the fields in the same position.
I have tried this formula -
=IF(E8="","",CONCATENATE(LEFT(TRIM($C8)&" “,50),” £",TEXT($D8,"#,##0.00"),CHAR(11)," - £",TEXT($E8,"#,##0.00")))

But I still get different length text fields which means the formated currency fields don’t align. How can I get the text field to be concatenated at a fixed 50 (or whatever length) chars?

[sokol92]

@steveTu

(LEFT(TRIM($C8)&" “,50

Use the design
(LEFT(TRIM($C8)&REPT(" ";50);50))

[steveTu]

@sokol92
Thanks for the reply! I have just tried that and got the same - BUT, thanks to your reply it dawned on me what was wrong … the concatenated cell was using a proportional font, and as soon as I changed it to a monospace font it all worked fine. So obvious but it took all afternoon and your reply to get me to see it!
Thanks again.