excel worksheet functions
 

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

excel worksheet functions
 

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

excel worksheet functions
 

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

"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

excel worksheet functions
 

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/micro...e=source&hl=en
--
David Biddulph

"yshridhar" wrote in message
...
thank you for your reply
but i could not find the site
shridhar

"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

excel worksheet functions
 

Thank u Mr. David
for your help
With compliments
Sridhar


"David Biddulph" wrote:

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/micro...e=source&hl=en
--
David Biddulph

"yshridhar" wrote in message
...
thank you for your reply
but i could not find the site
shridhar

"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