Merge columns, making the first column bold using formula, functions or code ?

Originally Posted by utilae

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?

No, you cannot fontset something that is a number or a formula.

If you Paste Special = Values you can then set font characteristics on portions of the text, with statements such as

Please Login or Register  to view this content.

etc.

hth
---