Excel Characters

[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

 

[Frank Kabel]

Hi
use the characters property of a cell range for this

 

[Stephen Rasey]

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

 

[Ken Hutson]

That does it for me.

Thanks guys,
Ken Hutson
San Antonio, TX