if it is a string like
xxxxyyyyzzzz
then just place your cursor in the FORMULA BOX and highlight what you want
to change. This can be done with a macro using

Characters Property
See Also Applies To Example Specifics
Returns a Characters object that represents a range of characters within the
object text. You can use the Characters object to format characters within a
text string.

expression.Characters(Start, Length)

--
Don Guillett
SalesAid Software

"Steen" wrote in message
...
Any chance that you know how to do the task with converting it to a string
and make the headline bold?

"Don Guillett" wrote:

You can't in a formula. You will need to convert to a string and then you
can bold part of it.

--
Don Guillett
SalesAid Software

"Steen" wrote in message
...
Hi
Can anyone help me with the following problem:

A B C
HeadLine Description Bold(Headline)
Description

I have found the first part of the solution elsewere on the site:
C1 = A1 & Char(10) & B1

But how do I set the Headline in Bold and not the description in C1 -
is
it
possible?