Join bold and non-bold text in one cell

  • Thread starter Thread starter bkincaid
  • Start date Start date
B

bkincaid

Does anyone know how to combine bold and non-bold text into one cell?
For example, let's say you have a name (Matt) that you want bolded an
a number (10) that you want regularly formatted. You also want to ad
a comma and a space. Your new string would look like this: Matt, 1
(with Matt bolded). I've tried using TEXT and CONCATENATE functions
but I always lose the bold formatting
 
Take the result of the CONCATENATE() and copy it then paste/special as value.
In this form you can select parts of the string and format them as bold.
 
You can't change the format using a formula.

If you had the text "Matt, 10" in a cell, then you could edit the cell
and highlight "Matt" and then turn bold on to affect only this part.

Hope this helps.

Pete
 
Does anyone know how to combine bold and non-bold text into one cell?
For example, let's say you have a name (Matt) that you want bolded and
a number (10) that you want regularly formatted. You also want to add
a comma and a space. Your new string would look like this: Matt, 10
(with Matt bolded). I've tried using TEXT and CONCATENATE functions,
but I always lose the bold formatting.
Click to expand...

The only way I know of to format different parts of a string differently,
within the same cell, is to

1. Have a string in the cell (NOT a formula).
2. Select the particular characters you wish to format and format accordingly.

This can also be done using a VBA macro, but you do have to have a string in
the cell.

If you could give more details on how your data is set up, it should be
possible to construct a macro to do this.
--ron
 
Back
Top