How to ADD a line-feed or BREAK to Chart Title?

[flightsim.gregory]

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

 

[Gord Dibben]

In your reference cell.

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

Format to wrap text.


Gord Dibben MS Excel MVP

 

[flightsim.gregory]

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

-G

 

[flightsim.gregory]

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

 

[Gord Dibben]

=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

 

[flightsim.gregory]

=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!!

 

[djslowboil]

Thanks awfully mate.. works like a champ!!

Perfect solution! Thanks!