different fonts concatenated

Hi,

I have a spreadsheet where text in column B is in one font (Symbol) and text in column A is in Times New Roman.

I want to be able to concatenate cells from column A and cells from column B (eg in cell C2 I would enter =concatenate(A2,B2))

How can I do this and keep the original formatting from A2 and B2 in C2?

Hi David,

I don't think this can be done with formulas, but a macro would work. The one below only works on cells A2, B2 and C2, but could be modified to go down all three columns as needed.

Please Login or Register  to view this content.