ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to mix fonts in a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/231788-how-mix-fonts-cell.html)

Machinist60

How to mix fonts in a cell?
 
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.

Don Guillett

How to mix fonts in a cell?
 
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.



Machinist60

How to mix fonts in a cell?
 
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.





All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com