I would like to make certain text within a cell bold. This is normally
straight forward when everything in a cell is text, the trouble lies when the
text to be displayed is dependent on formula.
For example, if A1="Mr" and B1="Smith". I can make cell B2 refer to cells A1
and B1 to display "How is Mr Smith today?", with the following code:
B2= "How is " & A1 & " " & B1 & " today?"
However, I'd like to be able to display only the text "Mr Smith" in bold. Is
there a simple way to amend the formula above to make this happen?