Need to separate Alt+Enter texts to individual cells

Hello Friends

The Cells in Column A may be blank, may be with or without sentences with Alt+Enter.

Now need to separate by formulas as shown below in light yellow cells.

The cells may have blank Alt+enters without texts (Example cells : A17, A20), and blank cells (Example cells : A16, A19, A21:A24, A28:A29) need to be ignored.

thanks in advance

In "C16"

Formula:

Please Login or Register  to view this content.

In "C17"

Formula:

Please Login or Register  to view this content.

In "C18"

Formula:

Please Login or Register  to view this content.

Same above formula to apply for others cell. Need to change only range.

Hello avk

Thanks for your formulas.

These formulas working by searching the fullstop. But this is just example file and real application will vary this. Can we have some formuals to realize the Alt+Enter entry inside the cells.

thanks again