ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Format Concatenate Entries (https://www.excelbanter.com/excel-programming/292196-format-concatenate-entries.html)

DrHunter

Format Concatenate Entries
 
Hi All,

I am trying to concatenate different references into one Cell. However i
would like some part of the concatenation to be concatenated in different
ways eg bold, italics, underline and font size.

= A1 &" Bold Text " &A2 &" Italics Text " &A3 &" Different Font sized Text "

Thanks in advance.



Frank Kabel

Format Concatenate Entries
 
Hi
see your replies in Excel.worksheet.functions
P.S.: please don't multipost as this scatters your anwers

--
Regards
Frank Kabel
Frankfurt, Germany

DrHunter wrote:
Hi All,

I am trying to concatenate different references into one Cell.
However i would like some part of the concatenation to be
concatenated in different ways eg bold, italics, underline and font
size.

= A1 &" Bold Text " &A2 &" Italics Text " &A3 &" Different Font sized
Text "

Thanks in advance.



JE McGimpsey

Format Concatenate Entries
 
See one answer in worksheet.functions.

Please don't post the same message to different newsgroups. It tends to
fragment any answers you get, and potentially waste the time of those
replying to questions that have already been answered.


In article ,
"DrHunter" wrote:

Hi All,

I am trying to concatenate different references into one Cell. However i
would like some part of the concatenation to be concatenated in different
ways eg bold, italics, underline and font size.

= A1 &" Bold Text " &A2 &" Italics Text " &A3 &" Different Font sized Text "

Thanks in advance.




All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com