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

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?

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?

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

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

"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?

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

On 2/22/2010 8:09 AM, Andy Bailey wrote:
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?

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

Bill