Concatenate range of cells with header values

November 28, 2011 at 12:31:45
Specs: Windows XP
I need to concatenate a range of cells (approx. 50) across a row (for many rows in my spreadsheet) and before each cell value, insert the cell's header row value. The header value and cell value needs to be separated by [:]

Each header/value pair needs to be separated by [;]

Example: Color[:]Red[;]Size[:]Large[;]Length[:]Long

VB preferred. Many thanks!

See More: Concatenate range of cells with header values

Report •

November 28, 2011 at 14:35:52
Without a more detailed explanation of how your sheet is laid out there's no way for anyone to write any code that will do what you ask. We don't know which Rows/Columns to reference, how many cells you need to concatenate, etc.

If you are going to post an example of your data, please click on the following line and read the instructions found via that link.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question