Formatting question

maryland_actuary · Mar 12th, 2002, 08:00 AM

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. · Mar 12th, 2002, 08:04 AM

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

Dave Hawley · Mar 12th, 2002, 08:05 AM

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 · Mar 12th, 2002, 08:08 AM

What is a VBA custom function?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 08:00 AM	#1
maryland_actuary New Member Join Date: Mar 2002 Posts: 2	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.

Mar 12th, 2002, 08:04 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Font formatting cannot be applied to a formula or cell reference. It can only be directly applied to text.

Mar 12th, 2002, 08:05 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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.

Mar 12th, 2002, 08:08 AM	#4
maryland_actuary New Member Join Date: Mar 2002 Posts: 2	What is a VBA custom function?