This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Good Morning!
I have a very specific job parameter that seems to be harder to achieve than I think it should be.
Basically, I am using Excel to generate labels/placards that use information from another table. Each label is a single cell that is referencing an entire table column, which is easy enough to do with added line breaks in between to separate said information. The difficult part comes with formatting the text as each "line" within a label cell needs different formatting. For example:
| Name 1<br><br>Description 1 |
|---|
would be generated from:
| Label | |
|---|---|
| Name | Name 1 |
| Description | Description 1 |
While I understand how to make the first table out of two cells and "faked" to appear as a single one, the issue comes from the fact that each label has a static size (2.5" in this case), the text needs to be justified both horizontally and vertically, as well as each line within the cell having different formatting, AND each label may have anywhere from three to seven rows so it's justification will be dynamic.
I am able to reference and create the labels from a purely data standpoint, but it means that I cannot format each line of text within the cell (font size, italicized, etc.), inside of the formula bar. To elaborate on what exactly I did to achieve that, this is my formula:
=Input!B1&IF(ISTEXT(Input!B2),CHAR(10)&Input!B2,"")&IF(ISTEXT(Input!B3),CHAR(10)&Input!B3,"")&IF(ISTEXT(Input!B4),CHAR(10)&Input!B4,"")&IF(ISTEXT(Input!B5),CHAR(10)&Input!B5,"")&IF(ISTEXT(Input!B6),CHAR(10)&Input!B6,"")&IF(ISTEXT(Input!B7),CHAR(10)&Input!B7,"")
Where "B1" is the first cell of data on a table within the sheet "Input". A little janky but it's mostly formatted to not add line breaks if a referenced cell is empty. With this I have exactly what I need besides the lines being visually formatted to be bold or larger or italicized.
Is there a way to achieve this through different means? I haven't found much information beyond some very specific VBA code but it seems I can't format text that way within the formula bar unfortunately.
If any elaboration is needed I would be happy to do so, thanks in advance for the help!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Which is what I was worried about.
I am open to ideas on how to achieve the same effect through different means, it can be in different cells in the end if it formats the same way.
Thanks
It is impossible to format parts of the result of a formula differently from the rest of the output.
It is only possible to format individual parts of the contents of a cell if that cell contains a value, not if it contains a formula.