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(10)&A4 and the output in cell A1 is
Travel by coach
But I require,
Anybody have any ideas how to do this? I've tried and failed. Any suggestions appreciated.
You can't keep text formatting with formulas, they work with values. That's only with VBA coding.