How to concatonate two words with first word in BOLD format?

N

nculbert

I want to concatenate two words from two different columns but I want the
first word in Bold, the second word not in bold. Is there a way to do this
in Excel?
 
A

Andy Bailey

If the first word is in A1, second in A2 then use:-

=CONCATENATE(UPPER(A1),A2)

Hope this helps.

Andy
 
J

JLatham

Andy Bailey has probably given you as good a solution as you're going to get
without resorting to VBA.
 
B

Bill

If the first word is in A1, second in A2 then use:-

=CONCATENATE(UPPER(A1),A2)

Hope this helps.

Andy
Click to expand...

That gets you upper case, which should stand out pretty well in
appearance. Good suggestion, Andy!

Bill
 

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

Similar Threads

Concantenate which keeps bold of some parts. 5
How to change format for an individual word in a cell 1
Bold rectangle cursor in VB Editor 3
Need to bold a cell based on keyword in another cell... 3
Bold 2
Bold Subtotals 3
How do I bold face text1 but not others in a concatenate string? 1
Concatenate and maintain format of original cells 2

Top