| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different Font Sizes In The Same Cell
Greetings,
I have a cell formula that retrieves data from three cells and puts them together like so: =A1&CHAR(10)&B1&CHAR(10)&C1 The CHAR(10) is a some kind of line feed to give me the stacked data look. Is it possible to make the display of the contents of A1 bigger then the other two? The default font size is 10. I would like the data from A1 to be 16. I know it can be done if I entered just text (not a formula), but I can't figure out how to do it in a formula, Anyone have any ideas or suggestions as to how this can be accomplished? As always, any help will be appreciated. -Minitman |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Different Font Sizes In The Same Cell
If you want to keep the formula, then it's not possible. You can't do this kind
of character by character formatting with formulas. Minitman wrote: Greetings, I have a cell formula that retrieves data from three cells and puts them together like so: =A1&CHAR(10)&B1&CHAR(10)&C1 The CHAR(10) is a some kind of line feed to give me the stacked data look. Is it possible to make the display of the contents of A1 bigger then the other two? The default font size is 10. I would like the data from A1 to be 16. I know it can be done if I entered just text (not a formula), but I can't figure out how to do it in a formula, Anyone have any ideas or suggestions as to how this can be accomplished? As always, any help will be appreciated. -Minitman -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Different Font Sizes In The Same Cell
Hey Dave,
Thanks for the reply, I needed to know that. The only work around I am aware of is to split the formula into separate cell and format each differently. I was hoping to avoid that. BTW - Did MS make that feature available in Office 2007 by any chance? -Minitman On Mon, 14 Apr 2008 18:52:49 -0500, Dave Peterson wrote: If you want to keep the formula, then it's not possible. You can't do this kind of character by character formatting with formulas. Minitman wrote: Greetings, I have a cell formula that retrieves data from three cells and puts them together like so: =A1&CHAR(10)&B1&CHAR(10)&C1 The CHAR(10) is a some kind of line feed to give me the stacked data look. Is it possible to make the display of the contents of A1 bigger then the other two? The default font size is 10. I would like the data from A1 to be 16. I know it can be done if I entered just text (not a formula), but I can't figure out how to do it in a formula, Anyone have any ideas or suggestions as to how this can be accomplished? As always, any help will be appreciated. -Minitman |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Different Font Sizes In The Same Cell
Nope--not on xl2007.
Minitman wrote: Hey Dave, Thanks for the reply, I needed to know that. The only work around I am aware of is to split the formula into separate cell and format each differently. I was hoping to avoid that. BTW - Did MS make that feature available in Office 2007 by any chance? -Minitman On Mon, 14 Apr 2008 18:52:49 -0500, Dave Peterson wrote: If you want to keep the formula, then it's not possible. You can't do this kind of character by character formatting with formulas. Minitman wrote: Greetings, I have a cell formula that retrieves data from three cells and puts them together like so: =A1&CHAR(10)&B1&CHAR(10)&C1 The CHAR(10) is a some kind of line feed to give me the stacked data look. Is it possible to make the display of the contents of A1 bigger then the other two? The default font size is 10. I would like the data from A1 to be 16. I know it can be done if I entered just text (not a formula), but I can't figure out how to do it in a formula, Anyone have any ideas or suggestions as to how this can be accomplished? As always, any help will be appreciated. -Minitman -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Different Font Sizes In The Same Cell
Oh Well.....
Thanks. -Minitman On Mon, 14 Apr 2008 20:07:00 -0500, Dave Peterson wrote: Nope--not on xl2007. Minitman wrote: Hey Dave, Thanks for the reply, I needed to know that. The only work around I am aware of is to split the formula into separate cell and format each differently. I was hoping to avoid that. BTW - Did MS make that feature available in Office 2007 by any chance? -Minitman On Mon, 14 Apr 2008 18:52:49 -0500, Dave Peterson wrote: If you want to keep the formula, then it's not possible. You can't do this kind of character by character formatting with formulas. Minitman wrote: Greetings, I have a cell formula that retrieves data from three cells and puts them together like so: =A1&CHAR(10)&B1&CHAR(10)&C1 The CHAR(10) is a some kind of line feed to give me the stacked data look. Is it possible to make the display of the contents of A1 bigger then the other two? The default font size is 10. I would like the data from A1 to be 16. I know it can be done if I entered just text (not a formula), but I can't figure out how to do it in a formula, Anyone have any ideas or suggestions as to how this can be accomplished? As always, any help will be appreciated. -Minitman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change all text one font size up with various font sizes used. | New Users to Excel | |||
| Multiple font sizes in a single cell | Excel Programming | |||
| Is it possible to format a cell w/ 2 font sizes by formula? | Excel Worksheet Functions | |||
| Can you mix font sizes in a cell? | New Users to Excel | |||
| Mixing Font Sizes In A Cell Formula | Excel Worksheet Functions | |||
Linear Mode
