Adding Line Break after specific character

Try:

Formula:

=SUBSTITUTE(A1, ">.", CHAR(10))

and Wrap Text

This works a treat! But to take it one step further, how would I add two line breaks instead of one?

You should be able to use something like this:

=SUBSTITUTE($A1," >. ",CHAR(10))

But you'll have to make sure the cell in which you place the formula has "Wrap text" enabled. Use Ctrl+1 on the cell, select the Alignment tab and check the box.

WBD

Try this:

=SUBSTITUTE(A1, ">.", CHAR(10)CHAR(10))

Try:

Formula:

=SUBSTITUTE(A1, ">.", CHAR(10) & CHAR(10))

You're welcome. Thanks for the rep.