Using Format Codes in Formulas

[excel_slave]

I am joining 2 text strings together using a formula like this:

="text "&A1&" "&A2

However, I would like the result of this formula to show the text that is in A1 not bolded and the text that is in A2 bolded. Is there a way to use format codes within the formula to accomplish this?

 

[VoG]

Sorry, a formula can only return a value. It cannot apply formatting.

 

[T. Valko]

I am joining 2 text strings together using a formula like this:

="text "&A1&" "&A2

However, I would like the result of this formula to show the text that is in A1 not bolded and the text that is in A2 bolded. Is there a way to use format codes within the formula to accomplish this?

That's not possible using worksheet formulas. Worksheet formulas can only return a value, not formatting.

 

[excel_slave]

That is not completely accurate. It might not be possible to format bold like I want to but if I have:

"You owe me " in cell A1
20 in cell A2

and type this formula in A3:
=A1&TEXT(A2,"$#,##0.00_)")

The result will be: You owe me $20.00
it doesnt matter how cell A2 is formatted

I didnt know if there was a similar format code/mask to use if you want to make it bold.

Thanks

 

[T. Valko]

That is not completely accurate. It might not be possible to format bold like I want to but if I have:

"You owe me " in cell A1
20 in cell A2

and type this formula in A3:
=A1&TEXT(A2,"$#,##0.00_)")

The result will be: You owe me $20.00
it doesnt matter how cell A2 is formatted

I didnt know if there was a similar format code/mask to use if you want to make it bold.

Thanks

That formula did not return a format. It returned a value where the form of the value was manipulated through the TEXT function.

You can not return a format with a formula.