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.
--
Gary's Student


"bkincaid" wrote:


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: http://www.excelforum.com/member.php...o&userid=32654
View this thread: http://www.excelforum.com/showthread...hreadid=524607