How do I bold face text1 but not others in a concatenate string?

J

Jennifer

Text 1 is a first name (i.e. Jane)
Text 2 is a last name (i.e. Doe)
I want to concatenate them but have the first name in regular font and the
last name in bold font.
 
D

Dave Peterson

You could use:
=a1 & " " & b1
to concatenate the values in two cells.

But as long as you keep the formula, you can't use character by character
formatting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top