Spilt a sentence into 3

[DEEARO]

Hi all

Thank you in advance your help is always appreciated.

i wanted to spilt a sentence into 3.

there are common words in the sentence which helps, ADDED, DUE.

i have attached sheet to help understand better.

[Metoo7]

use this formula for C5, drag and fill to the range.

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A5,"Added",REPT(" ",99)),"Due",REPT(" ",99)),COLUMN(A1)*99-98,99))

[AliGW]

In C2:

=LEFT(A5,SEARCH("Added",A5)-2)

In D2:

=TRIM(MID(A5,SEARCH("Added",A5)+5,12))

In E2:

=TRIM(MID(A5,SEARCH("Due",A5)+4,12))

[AliGW]

Thanks for the rep.