Forum Discussion
Rambler
Feb 16, 2019Copper Contributor
Merging text cells but keeping the font from each source cell.
Hi, I need to merge several text cells but keep the original font from the source cells. For example: A2 =Destination London A3 =Travel by coach A4 =Cost £80 I input into A1 =A2&CHAR(10)&A3&CHAR(...
SergeiBaklan
Feb 16, 2019Diamond Contributor
Hi,
You can't keep text formatting with formulas, they work with values. That's only with VBA coding.