Excel Formula to select words (txt) in a cell

[chris1979]

Hi Guys
Need your assistance in creating a formula

For eg : the txt as below
Returned Ticket Notification INC000000515843 Returned CI: SAP: Transport Equip Missing Information

Want to get the word after "Returned CI" i.e in this case it is SAP

Want another formula to get the string after SAP i.e I should get Transport Equip Missing Information

Please note that there might other special characters such "-" , ":" or blank space

Regards
CT

 

[chris1979]

Any assistance with this team ?

Essentially I have to SAP and Transport Equip Missing Information in different cells

CT

 

[Macropod]

This thread is a duplicate of: https://www.mrexcel.com/forum/excel...separate-subject-line-according-criteria.html

Kindly read Mr Excel's policy in Rule 12 against asking questions about the same topic in multiple threads: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html
Thread closed. You may continue the discussion in your other thread.