Formatting question

[maryland_actuary]

I need to be able to have separate formats inside of a formula. For example, I need to write the following:

="Hi, my name is "&@vlookup(table)

where @vlookup is referencing a table of names. I need the name only to be in bold.

 

[Mark W.]

Font formatting cannot be applied to a formula or cell reference. It can only be directly applied to text.

 

[Dave Hawley]

Hi maryland

You would need to do any Bolding via the normal format methods, ie toolbar. There is a Text function but it's really only for number formatting. The only other way would be relatively a simple VBA custom function, but seems a bit of overkill.

 

[maryland_actuary]

What is a VBA custom function?