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)
Hi
I want to bold certain areas of a text (only part of the text). For example
lets say I have the phrase ”Mr John Smith is a software engineer and is 42
years old”, where the name and age are taken from cells in the sheet 1 “ these
I want to appear as bold- and I also need the ”software engineer” to appear
as bold, though it is not drawn from any cell.
Is that possible without programming?
Thanks
Varun
ref link
http://www.computing.net/answers/office/how-to-bold-text-in-an-excel-formula/14425.html
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.
Answer accepted by question author
Formulas cannot retrieve the formatting, only the data. Once you have entered the formula, copy the cell and then paste/special/values back into the cell.
Then apply formatting to the pieces of text as you desire.
Why can't Microsoft add formatting formulas!!
Sad to see such a simple thing not possible in excel :(
Formulas cannot retrieve the formatting, only the data. Once you have entered the formula, copy the cell and then paste/special/values back into the cell.
Then apply formatting to the pieces of text as you desire.
If OP wanted to copy and paste there was no issue. Same problem. So is there some way like having HTML output and display same in cell. VBA Code is welcome.
Once the formula has been removed from the cell and has been replaced with the value that the formula returned, formatting can be applied on a character-by-character basis.