Thanks to all, but it dosn't solve my problem, because I want it to be done
automatically - any help on that?

A B C
HeadLine1 Decription1 HeadLine+Desc1 C1= (BOLD(A1)&char(10)&B1
HeadLine2 Decription2 HeadLine+Desc2 C2= (BOLD(A2)&char(10)&B2
HeadLine3 Decription3 HeadLine+Desc3 C3= (BOLD(A3)&char(10)&B3
....

Any help here?
"Ron Rosenfeld" wrote:

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