export multiple doc numbers and dates from same cell

[algere]

I am trying to search one column for two keywords: "CO" and "LOTD". I would like to export string with keywords starting with keyword "CO" or "LOTD" through date. i.e.

Start:

EA: Turned on per SAL from XXX to XX LOTD T020 dtd 23 FEB 10. Turned on per SAL from Fluor to DI LOTD T069 dtd 07 JUL 10.

<tbody>
</tbody>

End:
LOTD T020 dtd 23 FEB 10, LOTD T069 dtd 07 JUL 10


Please help!

 

[JLGWhiz]

JLGWhiz, I figured it out using a formula in the adjacent cell: =SUBSTITUTE($I2,CHAR(10)," ")

Thanks again for your help!

Glad you got it working
Regards, JLG