On a condition enter following text on next row?

dharberts

Is there a formula that states if ";" is recognized any text after is entered below?

Trying to take this:

To look like, with a formula:

Is this possible?

Mark.poole

@dharberts If it is all in the same column add a space between; and the next bit. Then use text wrapping. To achieve what your looking for. Shrink the size of the column until it wraps the text to what you want.

dharberts

I know the text wrap, but I want it to recognize the ";" and then do an ALT-ENTER and start the next section