As suggested from a previous post I am using the following formula to fill a
merged cell.

="(AO) "&'Source Doc'!B49&REPT(" ",49-LEN('Source Doc'!B49&'Source
Doc'!C49))&'Source Doc'!C49


I have a need to make the (AO) Bold & Italiacs, then the data from 'Source
Doc'!B49 should be bold and dark blue. Leaving the data from C49 as
formatted

Cells that contain formulas can't have this kind of character by character
formatting.

Yogi_Bear_79 wrote:
>
> As suggested from a previous post I am using the following formula to fill a
> merged cell.
>
> ="(AO) "&'Source Doc'!B49&REPT(" ",49-LEN('Source Doc'!B49&'Source
> Doc'!C49))&'Source Doc'!C49
>
> I have a need to make the (AO) Bold & Italiacs, then the data from 'Source
> Doc'!B49 should be bold and dark blue. Leaving the data from C49 as
> formatted

--

Dave Peterson

Bummer, thanks


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Cells that contain formulas can't have this kind of character by character
> formatting.
>
> Yogi_Bear_79 wrote:
>>
>> As suggested from a previous post I am using the following formula to
>> fill a
>> merged cell.
>>
>> ="(AO) "&'Source Doc'!B49&REPT(" ",49-LEN('Source Doc'!B49&'Source
>> Doc'!C49))&'Source Doc'!C49
>>
>> I have a need to make the (AO) Bold & Italiacs, then the data from
>> 'Source
>> Doc'!B49 should be bold and dark blue. Leaving the data from C49 as
>> formatted
>
> --
>
> Dave Peterson