Excel 2007: need to concatenate and retain italic formatting

[frankbosco]

Hi Mr.Excel/Excel gurus:

I'm trying to use Excel 2007 to concatenate author/journal source information... Specifically, I would like to concatenate some text (e.g., authors' names) in non-italic format - with some text (e.g., journal names) in italic format. The trouble is that the formula (i.e., concatenate) result removes the italic formatting. Is there anything akin to "=upper" that will provide italic formatting in a concatenate result?

Thanks in advance!
Frank Bosco

 

[Norie]

Frank

I'm sorry the answer to that is no, not even in 2007.

The only way to format the parts of a cell differently is via VBA.

And to do that you would need to replace the formulas with values.