View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Bold in string concatenation

On Sat, 28 Oct 2006 08:59:01 -0700, Steen
wrote:

Hi again

Any chance that you could help me with converting is to a string and make
the headline part bold?

"Ron Rosenfeld" wrote:

On Sat, 28 Oct 2006 05:39:01 -0700, Steen
wrote:

You cannot in Excel.

You can bold portions of strings, but not strings generated by formulas.

with a string in a cell, select the portion you wish bolded, and then select
Bold from the formatting controls.
--ron



Select the cell in which you have the string concatenation.

Place your cursor in the formula bar.

<F9
<Enter

In formula bar, select "headline part"

Then, either
Press the "B" button on the format toolbar
or
Format/Cells/Font Style BOLD


--ron