Excel Characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Group,

Consider the string "ab" in a cell. It's possible to
apply bold, underline italic etc.. to the "a" if you
like. That is, leave the "b" untouched. Is this bold,
underline, italic information accessible from the object
model? If so, where is it kept?

Thanks,
Ken Hutson
San Antonio, TX
 
Yes. At least in Office XP and later.

Just select the letters you want to apply formating and use the formatting
tool bar buttons.

For what it is worth, I always disable "Edit directly in cells" and I do my
editing in the Formula bar. However, I'll bet it works for selected
characters within the cell.

When you select a couple of characters in a cell even the Format Cells work.

You can only format text cells. Numbers cannot be formatted this way.
If you have a number, you must preceed it with a single quote for it to be
taken as a text string.

Stephen Rasey
WiserWays, LLC
Houston
http://excelsig.org
 
Back
Top