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(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
2 Replies
- RamblerCopper ContributorThanks Sergei - you've confirmed what I suspected.
- SergeiBaklanDiamond Contributor
Hi,
You can't keep text formatting with formulas, they work with values. That's only with VBA coding.