LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default Make 1st word in cell bold after combining words from two cells

I am combining the words from two cells, and I would like to change
the font of the first word in the combined cell. However, I keep
getting the font of the entire cell to change.

The cell has this formula, which draws text from two other pages in
the workbook, and it works fine

=Paragraphs!C8&" "&Details!B2

The first cell has about 60 characters in it, and the second cell
about 30 or so. The length of the first cell never varies, but the
length of the second cell does.

OK. So now the correct text is in the target cell. Now I want to
make the first word bold-face. I could not figure out how to do it
without VBA, so I tried to do this in single statement in a VBA
subroutine. It caused the entire cell to turn bold face..

ActiveCell.Characters(Start:=1, Length:=1).Font.FontStyle = "Bold"

What can I do? Any help is appreciated.
 
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
How to concatonate two words with first word in BOLD format? nculbert Excel Discussion (Misc queries) 3 February 22nd 10 10:20 PM
Can i make text in cells c60@n60 bold & black if sum of C59 is gre Spartan C10 Excel Worksheet Functions 7 February 7th 09 08:30 PM
How do i make certain words automatically bold themselves. INFO@Skyline New Users to Excel 6 November 9th 06 09:09 PM
Is it possible to make a word in a formula bold? SpielbergRules Excel Worksheet Functions 5 July 2nd 06 06:59 PM
Check for text within cells and make bold TroyB[_2_] Excel Programming 1 March 4th 04 12:20 AM


All times are GMT +1. The time now is 07:32 PM.

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"