Format part of a string...

  • Thread starter Thread starter mjack003
  • Start date Start date
M

mjack003

Hi,

This might be simple but what I need to do is format only part of
string. I have two sheets, an input sheet and a template sheet in th
same workbook. TemplateSheet!A1 is linked to
InputSheet!A1 with the following line:
"= "blah blah blah" & InputSheet!A1 & "blah blah blah"
What I need to do is format only the part from the input sheet as Bol
and underlined. The rest needs to hold the format of the cell. An
suggestions would be great.

Best Regards,
Mjac
 
Hi
formulas/functions can't change formats. They can only return values.
So this is not possible
 
This can only be done using VBA code. It's not just a simple functio
or formula like Frank said. If you are willing to post the workbook
we may be able to help you with some custom code to accomplish what yo
want.

Rolli
 
Hi
this can automatically only be done using an event procedure. But this
may depend on the kind of formula the OP is currently using :-)
 
Thank you for the input. I'd rather not create an event for somethin
so small so I solved it the easiest way possible. I pasted a white lin
over the part of the line that I did not want visible and since th
template sheet is protected this should work just fine :) Thanks agai
for the help.

Best Regards,
mjac
 
Just out of curiosity, if you don't want to show it, why even include it in the formula

Mark Graesse

----- mjack003 > wrote: ----

Thank you for the input. I'd rather not create an event for somethin
so small so I solved it the easiest way possible. I pasted a white lin
over the part of the line that I did not want visible and since th
template sheet is protected this should work just fine :) Thanks agai
for the help

Best Regards
mjac
 
Back
Top