View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Bailey Andy Bailey is offline
external usenet poster
 
Posts: 4
Default How to concatonate two words with first word in BOLD format?

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

=CONCATENATE(UPPER(A1),A2)

Hope this helps.

Andy

"nculbert" wrote:

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?