Extract data before a carriage return and after a semicolon

[daniels012]

I have data in a cell of lots of notes.
I have data all in one cell that is like this...

Company: Big Business Sales
12345 Long Drive
Pia, Long Island, NY 12345

Obviously separated by a carriage returns.
Can I make a formula to extract anything after company: and before the first carriage return.

Thank You for any help.
A formula please!!! No code if possible.

Michael

 

[daniels012]

Let me try again!

In cell N2 I have:

Company: Big Business Sales
12345 Long Drive
Pia, Long Island, NY 12345

Each line separated by carriage return

Can I have VBA code that will take the active cell and put in O2:
Company: Big Business Sales
P2:
12345 Long Drive
Q2:
Pia, Long Island, NY 12345
etc. etc. on down.
Have it do this after every carriage return no matter how many there are?

Please I thank you,
MIchael