Combining Cells BUT Keeping source formatting
 

Hi

I wish to combine cells in a worksheet - simple enough. However need to
keep the source cell formatting eg one is BOLD and one is ITALLIC. When I
combine using the stabdard commands eg =CONCATENATE(A2," ",B2) or =A2&" "&B2
the resulting combined cell resorts to the foramtting in the first cell.

Any offers

You can't have mixed formatting for the result of a formula.

--

Vasant


"FROSTY" wrote in message
...
Hi

I wish to combine cells in a worksheet - simple enough. However need to
keep the source cell formatting eg one is BOLD and one is ITALLIC. When I
combine using the stabdard commands eg =CONCATENATE(A2," ",B2) or =A2&"
"&B2
the resulting combined cell resorts to the foramtting in the first cell.

Any offers