Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How can I bolden H8 in the formula =(I8)&UPPER(H8)&CHAR(10)&B8?

Trying to bolden the upper case text from my "title" column(H).
I'm a newbie so the whole formula would be helpful.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default How can I bolden H8 in the formula =(I8)&UPPER(H8)&CHAR(10)&B8?

You can't.

If you have just text in a cell, then you can apply formats to part of the
text string, but if you have a formula you can't apply different formats to
different parts.
--
David Biddulph

"tonyanj" wrote in message
...
Trying to bolden the upper case text from my "title" column(H).
I'm a newbie so the whole formula would be helpful.



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
FIND 1 char in cell of any 3 char =True Nastech Excel Discussion (Misc queries) 5 April 26th 08 02:17 PM
WHY: Jump to other cell when First char entered is upper case (2007) Poul Nielsen Setting up and Configuration of Excel 0 March 22nd 08 01:16 PM
Changing upper case characters to upper/lower Richard Zignego Excel Discussion (Misc queries) 1 December 17th 07 10:09 PM
8500 cells with phone number(7 char.), wishing to add area code (10 char.) [email protected] Excel Discussion (Misc queries) 6 March 10th 06 05:13 PM
How do I convert all upper case excel sheet into upper and lower . DebDay Excel Discussion (Misc queries) 1 March 9th 05 08:31 PM


All times are GMT +1. The time now is 03:56 AM.

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

About Us

"It's about Microsoft Excel"