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
 
Top