I am a relative newbie to spreadsheets. I have constructed a text table in
Quattro Pro X3 and need to transfer it to Excel 2007 because of formatting
problems when publishing to pdf. I have been able to format ok and get all
the text onto Excel with excetion of special characters. From what I have
read I need to mix fonts within a cell. How to do this eludes me. Both
general and text data types don't seem to permit changing fonts for selected
characters. I have experimented with the char function but can't get the
display I want. I want to insert wingding characters into a regular font
string.

Help appreciated, John.

In a formula, you can NOT do this. In all text simply highlight the
characters in the cell desired (in the formula bar) right clickchange as
desired.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Machinist60" wrote in message
...
I am a relative newbie to spreadsheets. I have constructed a text table in
Quattro Pro X3 and need to transfer it to Excel 2007 because of formatting
problems when publishing to pdf. I have been able to format ok and get
all
the text onto Excel with excetion of special characters. From what I have
read I need to mix fonts within a cell. How to do this eludes me. Both
general and text data types don't seem to permit changing fonts for
selected
characters. I have experimented with the char function but can't get the
display I want. I want to insert wingding characters into a regular font
string.

Help appreciated, John.

Thanks Don. I guess I tried most ways except in formula bar. John.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

"Don Guillett" wrote:

In a formula, you can NOT do this. In all text simply highlight the
characters in the cell desired (in the formula bar) right clickchange as
desired.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Machinist60" wrote in message
...
I am a relative newbie to spreadsheets. I have constructed a text table in
Quattro Pro X3 and need to transfer it to Excel 2007 because of formatting
problems when publishing to pdf. I have been able to format ok and get
all
the text onto Excel with excetion of special characters. From what I have
read I need to mix fonts within a cell. How to do this eludes me. Both
general and text data types don't seem to permit changing fonts for
selected
characters. I have experimented with the char function but can't get the
display I want. I want to insert wingding characters into a regular font
string.

Help appreciated, John.