Feb 16 2019 02:29 AM
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(10)&A4 and the output in cell A1 is
Destination London
Travel by coach
Cost £80
But I require,
Destination London
Travel by coach
Cost £80
Anybody have any ideas how to do this? I've tried and failed. Any suggestions appreciated.
Thanks
Feb 16 2019 03:12 AM
Hi,
You can't keep text formatting with formulas, they work with values. That's only with VBA coding.
Feb 16 2019 03:50 AM