Hi everyone!

I need help on formatting concatenated items.

Say, cell A1 contains a text, "dog", and is in bold format.

I'll type in cell B1:

="I have a "&A1&"."

which will return: "I have a dog."

What I want actually for cell B1 to show is: "I have a dog."

I can't seem to figure out how to do it. Is it even possible? Help!! Thanks


Erik