How to add hard line break to formula/cell?

[kit99]

Got this formula in my sheet: =LEFT(R3,15).
It return the first 15 characters from cell R3.

Is there a way I can add hard line break to this formula - after character number 8?
What I've found online so far (CHAR) seems to pick data from 2 columns, adding char between them...

My aim is to make my info text at the bottom of my bar graph look nice.

 

[Rick Rothstein]

Change your formula to this one...

=REPLACE(LEFT(R3,15),9,0,CHAR(10))

Don't forget to turn "Wrap Text" on for the cell you put the formula in and also make sure the cell's column width is wide enough to display at least 8 characters minimum.

 

[kit99]

Change your formula to this one...

=REPLACE(LEFT(R3,15),9,0,CHAR(10))

Don't forget to turn "Wrap Text" on for the cell you put the formula in and also make sure the cell's column width is wide enough to display at least 8 characters minimum.

Thanks a lot for helping out!
That worked fantastic.