Bolding literal text strings in a concatenate function

[SJD]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello!

I've gotten a concatenate function to work exactly like I want it to, except that I can't seem to bold some of the literal (enclosed in "") text strings in the formula. The bold button is unavailable (grayed-out).

Since I can't use the bold button, is there a bold command that I can put into the formula? I know it's goofy, but I tried the HTML /<b>.../</b> tags just in case it worked, but it didn't.

Thanks so much for any help!! I'd REALLY appreciate it!
Best,
-Sarah

 

[CyberTaz]

Hi Sarah -

I'm sure someone will be along to correct me if I'm wrong , but I don't
believe there is any way to get a formula to return character formatting or
to include it as a part of the expression.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello!

I've gotten a concatenate function to work exactly like I want it to, except
that I can't seem to bold some of the literal (enclosed in "") text strings in
the formula. The bold button is unavailable (grayed-out).

Since I can't use the bold button, is there a bold command that I can put into
the formula? I know it's goofy, but I tried the HTML /<b>.../</b> tags just in
case it worked, but it didn't.

Thanks so much for any help!! I'd REALLY appreciate it!
Best,
-Sarah

Cybertaz is right. You can not format part of a formula. The only thing you
can do here is to set the font attributes of the entire cell containing the
formula.

 

[SJD]

Hello!

Thanks so much for the clarification!

I actually figured out a way to do what I want - my goal with the concatenate formula was to merge several columns into one, formatted the way I wanted, to import with the rest of a CSV into a MySQL table.

In the end, I realized that even though Excel doesn't use HTML tags to display formatting, the browser using the table data would, so I inserted the bold tags where I wanted them in the formula (enclosed in quotes as part of the literal string) and, after upload, the formatting was perfect!

Thanks again!
-SJD