Can I change a portion of a string to bold in a cell?

[djpingpong]

Hi,

I have a cell with the following content

="some string 1..."  & someVariable & " some string 2...."

Normally, that would just concatenate the three parts together into one string
However, I need the portion " some string 2..." formatted BOLD in the end-result display

Is that possible? Is there anything in excel that's similar to HTML (ie: <b> ... </b>)
Or is my only option to separate them into different cells?


cheers

 

[SkipVought]

Hi,

Not possible to do if there is a formula in the cell.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[AnotherHiggins]

Sorry - worksheet formulas only return data, they can't impart formatting.

Conditional Formatting can impart formatting to an entire cell, but not part of the cell.

You're stuck with either 1) clicking into the cell, selecting the portion you want in bold and applying the format yourself; 2) a VBA (macro) solution or 3) breaking up the data into three different cells and "bolding" (emboldening?) the one containing the desired string. This might work if this is just a report that will be viewed/printed.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[djpingpong]

that's ok.. i figure there was no way to do it...
thanks for the quick replies...
i ended up seperating it into 2 rows instead of concating it all in one cell