Forum Discussion

Rambler's avatar
Rambler
Copper Contributor
Feb 16, 2019

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

  • Rambler's avatar
    Rambler
    Copper Contributor
    Thanks Sergei - you've confirmed what I suspected.
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi,

     

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

Resources