Formatting - Combine data multiple columns to one column

[carrollm]

I have data in columns in excel that I want to combine into a single column with the data aligned as shown in the attachment
Thanks Carroll

[PaulM100]

There may be a VBA solution, but why do you wanna do this? if is only for display option you could get rid of the gridlines(from Ribbon - View - Untick Gridlines) and if is display+using it in a formula, use a simple concat without spaces and hide hide the helper column

[Pete_UK]

You don't really need to use the CONCATENATE function - you can do this to get fixed length records:

=A6&REPT(" ",20-LEN(A6))&B6&REPT(" ",64-LEN(B6))&C6&REPT(" ",7-LEN(C6))&D6&REPT(" ",45-LEN(D6))&E6

But to see the effect properly, you should use a non-proportional font, such as Courier New.

Hope this helps.

Pete

[carrollm]

Thanks for the reply Paul
This doesn't answer my need - see Pete_uk answer
Carroll

[carrollm]

Thanks Pete
This works great. I found it was necessary to use a non-proportional like the Courier New font
you suggested.
Thanks for your quick response
Carroll

[Pete_UK]

You're welcome, Carroll - thanks for feeding back.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

EDIT: You can, of course, change the numbers within the REPT functions if you want narrower or wider columns. Also, the entry in B12 does not have a leading space, whereas all other items in column B do, so there is a slight misalignment there if you do not add that space.

Pete