software

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.--
bkincaid
------------------------------------------------------------------------
bkincaid's Profile: www.excelforum.com/member.php...oamp;userid=32654
View this thread: www.excelforum.com/showthread...hreadid=524607Take 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.
--
Gary's Studentquot;bkincaidquot; wrote:

gt;
gt; Does anyone know how to combine bold and non-bold text into one cell?
gt; For example, let's say you have a name (Matt) that you want bolded and
gt; a number (10) that you want regularly formatted. You also want to add
gt; a comma and a space. Your new string would look like this: Matt, 10
gt; (with Matt bolded). I've tried using TEXT and CONCATENATE functions,
gt; but I always lose the bold formatting.
gt;
gt;
gt; --
gt; bkincaid
gt; ------------------------------------------------------------------------
gt; bkincaid's Profile: www.excelforum.com/member.php...oamp;userid=32654
gt; View this thread: www.excelforum.com/showthread...hreadid=524607
gt;
gt;

You can't change the format using a formula.

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

Hope this helps.

PeteOn Mon, 20 Mar 2006 17:19:54 -0600, bkincaid
gt; wrote:

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

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