MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formatting a Concatenated Value


Posted by Zeke Crowley on July 24, 2001 1:48 PM

Is there a way to format font in a Concantenated value? Ex: cell A1 contains the project name, and B1 contains the % complete. The concatenated formula is: =concatenate("Project: ",A1,", Progress: ",B1). I would like the values for A1 and B1 to be bold in the resulting concatenated value.


Posted by IML on July 24, 2001 1:52 PM


Maybe I'm misunderstanding, but just format your formula cell as bold. This should make the result bold regardless of how A1 and B1 are formatted.

good luck.

Posted by Lars on July 24, 2001 3:05 PM

In one cell this is what it will look like:

Project: "" Progress: ""

So you want the project name and Progress % bolded only not the word Project and Progress?


Posted by Mark W. on July 24, 2001 3:41 PM

Character formatting can only be performed on a
text value constants -- not on values returned
by a formula. Is there a way to format font in a Concantenated value? Ex: cell A1 contains the project name, and B1 contains the % complete. The concatenated formula is: =concatenate("Project: ",A1,", Progress: ",B1). I would like the values for A1 and B1 to be bold in the resulting concatenated value.

Posted by Zeke Crowley on July 25, 2001 5:49 AM

Project: "" Progress: "" So you want the project name and Progress % bolded only not the word Project and Progress?


Posted by Zeke Crowley on July 25, 2001 5:50 AM

Project: "" Progress: "" So you want the project name and Progress % bolded only not the word Project and Progress?


Posted by Zeke Crowley on July 25, 2001 5:51 AM

Project: "" Progress: "" So you want the project name and Progress % bolded only not the word Project and Progress?


Posted by Zeke Crowley on July 25, 2001 5:53 AM

Yes, that is what I was looking for. Only the project name and Progress % to be bolded.


Posted by Zeke Crowley on July 25, 2001 5:55 AM

Thank you for looking at this. Character formatting can only be performed on a