How to make labels from several cells of data in Excel

A few days ago I was given an Excel spreadsheet and asked to convert it into labels in just a few hours. The problem was that it was not just two columns of data for every row, but each row having an indeterminate number of columns of data (up to ten to be precise).

I was in a bind because I had to get it done quickly. I could have used Word, but that would have been very labour intensive, so the optimum solution would be to make the labels from the existing Excel worksheet.

I therefore made a copy of the original page because that would be the page that I would use to make the labels.

I made a piece of text on cell A1 that would be pasted to each label. I then used column K of the working page as the label.

The formula that I typed in to K4 and copied and pasted to each successive cell in column K was:-

=$A$1&CHAR(10)&B4&REPT(“ “,5)&C4&CHAR(10)&D4&REPT(“ “,5)&E4&CHAR(10)&F4&REPT(“ “,5)&G4&CHAR(10)&H4&REPT(“ “,5)&I4&CHAR(10)

The resulting labels in column K can be seen below:-