Format Concatenate

[James_Latimer]

Excel 2007
Hello, i was wondering if someone could advise me here please.

I have a cell that has the following in it......

="The total number of non compliant patients in the population is " & G27 &". This results in a wastage of £" & TEXT(G61,"#.#0") & ". There are also a further " &G29& " patients that currently overfill their perscriptions, resulting in an additional wastage of £"& TEXT(G63,"#.#0")&". "

The problem that i have is that the values that the cell references (ie G27) is in the same font settings as the rest of the text. Is there anyway to just change the formatting on these bits of the formula.
I know that this can be done when the cell contains text only but i cant seem to do it with formula.

I hope this makes sense.

Thanks to anyone who can assists.

 

[VoG]

Sorry, no, that is not possible with a formula.

 

[James_Latimer]

Bums!
I thought as much


Thanks anyway!

 

[James_Latimer]

Is it possible to create a user defined function of some description that would do be able to do this or is it simply a 'no-go' ?

 

[Armando Montes]

Maybe something like this:
http://www.mrexcel.com/forum/<WBR>showthread.php?t=156045&<WBR>highlight=concatenate+normal+<WBR>bold
You can't do it, if the cell contains formula.
This is just a sample
Select A1:A2, before you run the code

 Sub test()
Dim x, y
With Selection
    x = .Item(1).Text
    y = .Item(2).Text
    With .Item(1).Offset(, 1)
        .Value = x & y
        .Characters(Len(x) + 1, Len(y)).Font.Bold = True
    End With
End With
End Sub