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

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

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
<(E-Mail Removed)> 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

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
> <(E-Mail Removed)> 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

Oh Well.....

Thanks.

-Minitman

On Mon, 14 Apr 2008 20:07:00 -0500, Dave Peterson
<(E-Mail Removed)> 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
>> <(E-Mail Removed)> 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