Re: 2 different formats of text in a single cell?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If your text constant is abcdefghj, in the formula bar select the def, then
Format Cells will give you a font tab. Select the desired formatting, and
that will be applied to the def.
--
David Biddulph

"mopgcw" <mopgcw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EF44314B-728D-47CF-86AB-A3EEAFF3EA19@xxxxxxxxxxxxxxxx
Thanks, how would I format part of a text constant?



"Rick Rothstein" wrote:

You can't bold or italicize (or do any other font formatting to) part of
a
string of text if that text is displayed as the result of a worksheet
formula... only text constants can have parts of its text formatted
differently from the rest.

--
Rick (MVP - Excel)


"mopgcw" <mopgcw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:52471F62-C823-40A1-BA48-9240A2BC9EDC@xxxxxxxxxxxxxxxx
Is it possible to have more than one format for a text string in a
cell?

For example, I have the formula:

=i_currency&TEXT(+$C$13/landarea,"#,###.##")&"/"&landunit,"")

How can I bold or italicize part of the text string?

thanks
George





.

Relevant Pages

  • Re: Regular Expression - old regex module vs. re module
    ... The ReportTemplate class reads a template file or string containing a ... header and line format for multiple calls with sequence data. ... def _format: ...
    (comp.lang.python)
  • Enumerating formatting strings
    ... I was messing about with formatting and realized that the right kind of object could quite easily tell me exactly what accesses are made to the mapping in a string % mapping operation. ... return x def nameList: if self.names: ... I've been wondering whether it's possible to perform a similar analysis on non-mapping-type format strings, so as to know how long a tuple to provide, or whether I'd be forced to lexical analysis of the form string. ...
    (comp.lang.python)
  • Re: How to put multiple values into a variable.
    ... :file, filename, ... def Cons.list ... you want to format a string? ... I just can't format the string. ...
    (comp.lang.ruby)
  • Re: How to put multiple values into a variable.
    ... This is not quantic computing. ... def Cons.list ... you want to format a string? ... I just can't format the string. ...
    (comp.lang.ruby)
  • Re: reading specific fields from a file
    ... for which it would be painful to write out the textformat string ... format and a few of them with other formats: ... % build format string from format cells ...
    (comp.soft-sys.matlab)