Functions return values to their calling cells, they don't include
formatting.

To do what you're looking for requires an event macro.

See

http://groups.google.com/group/micro...msg/156b614dd2
904068?dmode=source&hl=en



In article ,
yshridhar wrote:

when i use concatenate, lookup functions i am losing the formating of my text
viz, Bold, underline or superscript. Who to preserve the formats after using
these functions