formatting functions

[John]

I have a cell in which I have some text within quotes that I an
concatenating with the results returned by a vlookup function. I cannot seem
to format only the text part of the cell. To illustrate, here is the
contents of the cell (I want only "Score:" to be in bold):
="Score: "&(VLOOKUP($A$1,'Game 1'!$A$2:$J$15,3,FALSE))

Thanks for any help!

John

 

[Don Guillett]

AFAIK you can NOT do that inside a formula. Only when it's all text.