Combine text into a sentence

[Shradharani]

Hi ,

I am working on 2010 excel and I am trying to combine few texts and end result is my complete sentence .In that complete sentence I want one letter in bold

Cell
A1 My
A2 name is
A3 Shradha

Formula A1&A2&A3

Sentence is “My name is Shradha “ in this sentence I want Shradha letter in bold.

Can you please help me this .
I am trying to post new post but not getting that option so replied to my previous post only .
Please help.

Thanks and regards,
Shradha

[aydeegee]

Hi Shradharani

I could not find a nice way of doing this, so here is a not-so-nice way. The only thing going for it is that it works.

Note that I have put in spaces to make a nice sentence, but if you do not need this, you will need to amend the "+1" and "+2" in the macro.

Let me know if it works for you