First copy the result of the formula and paste/special as value to an un-used
cell. Then, in the formula bar, select the regions of text and format them
individually
--
Gary's Student


"Robert57" wrote:


Ok. I will try to explain.
I want to join text from several cells and I'm using a function
"Sammafoga(A1;a2;a3)"
But I want the text to be formatted in the recevied cell, i.e. font
size from A1 shall be 18, a2 italic and a3 normal.

How do I do that?

tnx for your answer
Robert


--
Robert57
------------------------------------------------------------------------
Robert57's Profile: http://www.excelforum.com/member.php...o&userid=29838
View this thread: http://www.excelforum.com/showthread...hreadid=495454