Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change font formatting in a concatenated string
Following on to the previous question "How do I insert a hard break (alt
enter) in a concatenated string" where the answer was by inserting a CHAR(xx) string I wonder whether there are similar codes to eg make one element of a concatenated string bold or italic or underlined or ... This would come in particularly handy with strings that are displayed in text boxes - very practical for variable explanations on graphs. My current workaround is to put the string elements in separate text boxes, format them as required and then group them together. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change font formatting in a concatenated string
No there isn't. You need to use VBA to set the specific elements, but it is
a bind (IMO). -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Michael R" wrote in message ... Following on to the previous question "How do I insert a hard break (alt enter) in a concatenated string" where the answer was by inserting a CHAR(xx) string I wonder whether there are similar codes to eg make one element of a concatenated string bold or italic or underlined or ... This would come in particularly handy with strings that are displayed in text boxes - very practical for variable explanations on graphs. My current workaround is to put the string elements in separate text boxes, format them as required and then group them together. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mix font styles in concatenated text | Excel Worksheet Functions | |||
Splitting a concatenated string into separate rows... | Excel Worksheet Functions | |||
How do I break up a concatenated text string ? | Excel Discussion (Misc queries) | |||
Bold a portion of concatenated string | Excel Discussion (Misc queries) | |||
specify range name in formula with concatenated string | Excel Worksheet Functions |