Hi,

I have some columns in excel that need to be merged into one word, but the first column needs to be made bold in the merged result.
eg
...A.........................................B.......................C......................D
Merged..................................Name................Address...............City
-----------------------------------------------------------------------
Bob 9 Road Street Auckland.......Bob..................9 Road Street.......Auckland

Note above that in the merged column, 'Bob' would be made bold.

Now currently I have the following formula:
A=B1 & " " & C1 " " & D1

But I need to do something like:
A=Bold(B1) & " " & C1 " " & D1

Of course I can see no way to do this. Is there any way to do this?