Forum Discussion
Luxio1997
Oct 11, 2023Brass Contributor
Insert bold type inside the formula
Hello everyone, Could anyone help me find a way (WITHOUT USING MACROS OR VBA) to bold 12/15/1997, part of the result inside cell C4 containing the text 'I was born on ' and the TEXT formula? Thank ...
HansVogelaar
Oct 11, 2023MVP
That is impossible.
Excel does not support formatting part of the result of a formula differently from the rest.
I'd use two cells - one for the text "I was born on" and another for the date. Make the cell with the data bold.
Luxio1997
Oct 11, 2023Brass Contributor
I know, in fact that's how I started.
However, when I insert other wider lines underneath, "I was born on" and the date are too detached. Is there a way to make the rows move independently without having to adapt all the rows in the same column?
However, when I insert other wider lines underneath, "I was born on" and the date are too detached. Is there a way to make the rows move independently without having to adapt all the rows in the same column?
- mtarlerOct 11, 2023Silver ContributorHave you tried to format the "I was born on" column as right justified and then the date column as left justified?