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

  • Thread starter Thread starter flightsim.gregory
  • Start date Start date
F

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
 
In your reference cell.

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

Format to wrap text.


Gord Dibben MS Excel MVP
 
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
 
=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
 
=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
Click to expand...


Thanks awfully mate.. works like a champ!!
 
Back
Top