hi,
yes you can do that. in a regular text string. the code below show how it's
done.
but you can't do that in a formula. reason being you have to have exact
start and stop points and exact lengths in order to have different formats
within the same cell and formulas can produce varing results. sorry.

Sub differentformats()
'this bolds the word you and leave the other words regular
Range("C5").Select
ActiveCell.FormulaR1C1 = "'did you know"
With ActiveCell.Characters(Start:=1, Length:=4).Font
.Name = "Arial"
.FontStyle = "Regular"
.Size = 10
.ColorIndex = xlAutomatic
End With
With ActiveCell.Characters(Start:=5, Length:=3).Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 10
.ColorIndex = xlAutomatic
End With
With ActiveCell.Characters(Start:=8, Length:=5).Font
.Name = "Arial"
.FontStyle = "Regular"
.Size = 10
.ColorIndex = xlAutomatic
End With
End Sub

regards
FSt1
"dragonball20cal" wrote:


Hi I am have having problem applying bold format within string text. I
want to bold the Input!10 data pulled from another sheet. is there a
way to do this? is it even possible?

="your application will be renewing on"&" "&TEXT(Input!B10, "mmmm dd,
yyyy.")&" " & "In an effort to furnish you with the coverage that"



dan




--
dragonball20cal