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

  • Thread starter Thread starter nculbert
  • Start date Start date
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?
 
If the first word is in A1, second in A2 then use:-

=CONCATENATE(UPPER(A1),A2)

Hope this helps.

Andy
 
Andy Bailey has probably given you as good a solution as you're going to get
without resorting to VBA.
 
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
 
Back
Top