Using Textjoin to Extract Values in Col E1 to G50 in B2

[Howardc1001]

I have values in E1 to up to maximum range of G50

I want to extract these in B2 going across i.e for the three columns showing the headings and the values below the headers


I have managed to use this formula below but it does not align the numbers neatly below the headers

Please Login or Register  to view this content.

I have shown in B4 how I would like it to look like

It would be appreciated if someone could kindly amend my formula

[AliGW]

Why???

What's the objective? Are you trying to create a label of some sort?

This is going to be impossible without VBA, I think - the minute a column width is changed, whatever you do will get wrecked. You cannot force alignment using a formula, unfortunately.

[ByteMarks]

I tried two textjoins

=TEXTJOIN(REPT(" ",14),FALSE,$E$1:$G$1)&CHAR(10)&TEXTJOIN(REPT(" ",24),FALSE,E2:G2)

[Howardc1001]

This is brilliant-many thanks for the help

[Howardc1001]

Hi Ali

I use cell B2 and wrap the text to fit the data into this cell and name the cell and use this to import the data into the body of an email using VBA

[ByteMarks]

You're welcome