excel worksheet functions

[yshridhar]

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

 

[JE McGimpsey]

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/microsoft.public.excel.misc/msg/156b614dd2
904068?dmode=source&hl=en

 

[yshridhar]

thank you for your reply
but i could not find the site
shridhar

 

[David Biddulph]

If you are referring to JE McGimpsey's reply (though you seem to have
replied to your own message rather than his), then you need to ensure that
you include the full url, which may have wrapped from line to line in his
message.

He referred to:
http://groups.google.com/group/microsoft.public.excel.misc/msg/156b614dd2904068?dmode=source&hl=en

 

[yshridhar]

Thank u Mr. David
for your help
With compliments
Sridhar