I'm using a CELL to define a Chart Title but need to put a BREAK or
LINE FEED in the title string to force it to WRAP into two lines of
the same FONT Type. How can a BR, Break, or LF be inserted to WRAP a
long Title? Purpose is to then =CONCATENATE date and Serial No of
product into Title.

-G

In your reference cell.

Type line one<alt + enter> type line two <enter>

Format to wrap text.


Gord Dibben MS Excel MVP


On Wed, 22 Aug 2007 07:29:27 -0700, (E-Mail Removed) wrote:

>I'm using a CELL to define a Chart Title but need to put a BREAK or
>LINE FEED in the title string to force it to WRAP into two lines of
>the same FONT Type. How can a BR, Break, or LF be inserted to WRAP a
>long Title? Purpose is to then =CONCATENATE date and Serial No of
>product into Title.
>
> -G

Thanks.. works GREAT!! How come text cell gets so huge?

-G


On Aug 22, 10:56 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> In your reference cell.
>
> Type line one<alt + enter> type line two <enter>
>
> Format to wrap text.
>
> Gord Dibben MS Excel MVP
>
>
> On Wed, 22 Aug 2007 07:29:27 -0700, flightsim.greg...@yahoo.com wrote:
> >I'm using a CELL to define a Chart Title but need to put a BREAK or
> >LINE FEED in the title string to force it to WRAP into two lines of
> >the same FONT Type. How can a BR, Break, or LF be inserted to WRAP a
> >long Title? Purpose is to then =CONCATENATE date and Serial No of
> >product into Title.
>
> > -G- Hide quoted text -
>
> - Show quoted text -

Never mind HUGE cell.. that's fixed. Thanks

Now I need a LINE WRAP inside a =CONCATENATE function. Can this be
done? or some work-around? Basically building up a long string from
text-cells, and it has to WRAP in the Chart title.


-G


On Aug 22, 10:56 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> In your reference cell.
>
> Type line one<alt + enter> type line two <enter>
>
> Format to wrap text.
>
> Gord Dibben MS Excel MVP
>
>
>
> On Wed, 22 Aug 2007 07:29:27 -0700, flightsim.greg...@yahoo.com wrote:
> >I'm using a CELL to define a Chart Title but need to put a BREAK or
> >LINE FEED in the title string to force it to WRAP into two lines of
> >the same FONT Type. How can a BR, Break, or LF be inserted to WRAP a
> >long Title? Purpose is to then =CONCATENATE date and Serial No of
> >product into Title.
>
> > -G- Hide quoted text -
>
> - Show quoted text -

=A1 & B1 & C1 & CHAR(10) & D1 & E1 & F1 etc.

You don't need the CONCATENATE function when you use the ampersands.

The CHAR(10) is same as Alt + Enter

Insert it in your formula wherever you want a linefeed.


Gord

On Wed, 22 Aug 2007 09:07:15 -0700, (E-Mail Removed) wrote:

>
>Never mind HUGE cell.. that's fixed. Thanks
>
>Now I need a LINE WRAP inside a =CONCATENATE function. Can this be
>done? or some work-around? Basically building up a long string from
>text-cells, and it has to WRAP in the Chart title.
>
>
> -G
>
>
>On Aug 22, 10:56 am, Gord Dibben <gorddibbATshawDOTca> wrote:
>> In your reference cell.
>>
>> Type line one<alt + enter> type line two <enter>
>>
>> Format to wrap text.
>>
>> Gord Dibben MS Excel MVP
>>
>>
>>
>> On Wed, 22 Aug 2007 07:29:27 -0700, flightsim.greg...@yahoo.com wrote:
>> >I'm using a CELL to define a Chart Title but need to put a BREAK or
>> >LINE FEED in the title string to force it to WRAP into two lines of
>> >the same FONT Type. How can a BR, Break, or LF be inserted to WRAP a
>> >long Title? Purpose is to then =CONCATENATE date and Serial No of
>> >product into Title.
>>
>> > -G- Hide quoted text -
>>
>> - Show quoted text -
>

On Aug 22, 12:27 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> =A1 & B1 & C1 & CHAR(10) & D1 & E1 & F1 etc.
>
> You don't need the CONCATENATE function when you use the ampersands.
>
> The CHAR(10) is same as Alt + Enter
>
> Insert it in your formula wherever you want a linefeed.
>
> Gord
>


Thanks awfully mate.. works like a champ!!