ExcelBanter - Excel Characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel Characters (https://www.excelbanter.com/excel-programming/306837-excel-characters.html)

Excel Characters

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

Excel Characters

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

wrote in message
...
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

Excel Characters

That does it for me.

Thanks guys,
Ken Hutson
San Antonio, TX

wrote in message
...
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