Could anyone show me some code to automatically concatenate a range of cells whilst preserving the original formatting?
My document consists of around 200 columns and 16000 rows. Each row needs to be concatenated into column A with a "/" delimiter and preserve the original font (around 20 columns have red font which needs to be included in the destination cell).
Many thanks
Bookmarks