Forum Discussion
Solved
Retain text formatting when using Concat or Textjoin
Is it possible to retain text format when concatenating cells? In this example, I would like to combine cells a2, b2, and c2 retaining the italics formatting on a2. Thanks for your help.
No, it is not possible to format part of the result of a formula differently from the rest.
A possible workaround is to use VBA to populate E2 with a value instead of a formula and to apply the desired formatting. But it would be complicated to get this right in all possible situations.
3 Replies
create html by sql:
select *,Customer||'<i>'||Revenue||'</i>' from Sheet1
then copy to excel.
No, it is not possible to format part of the result of a formula differently from the rest.
A possible workaround is to use VBA to populate E2 with a value instead of a formula and to apply the desired formatting. But it would be complicated to get this right in all possible situations.
- Thanks
