I've been trying to write a macro to solve this problem all morning, so thought it was time to ask for help...
I'd like to concatenate the text in 2 rows.
Take the text in cells A1 to A100, add the text in adjacent cells B1 to B100 (adding a space between them) and output the result in the C column.
The data in the B column sometimes ends in a space, so the output in the C column also needs to be trimmed to remove any trailing spaces.
Any suggestions much appreciated, and I promise to mark this thread as solved when I find a solution