Merging text cells but keeping the font from each source cell.

Copper Contributor

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

Hi,

 

You can't keep text formatting with formulas, they work with values. That's only with VBA coding.

Thanks Sergei - you've confirmed what I suspected.