Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,624
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format CONCATENATE Dave Excel Discussion (Misc queries) 3 August 20th 07 08:22 PM
Concatenate format Tom Excel Worksheet Functions 5 June 4th 07 11:42 AM
CONCATENATE And Date Format Joseph Zuraski II Excel Discussion (Misc queries) 9 November 26th 06 01:51 PM
Concatenate Unique Entries SteveT Excel Discussion (Misc queries) 4 April 29th 06 02:11 AM
concatenate and format Mauro Excel Worksheet Functions 1 November 18th 04 07:09 PM


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"