|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 [;]
VB preferred. Many thanks!