Extract and Replace Specific Text from Cell To Another Cell

[Hany ali]

Hello My Dear Colleagues .. I want Your Help To Extract the Text From First Column A To two Columns B & C ,as You See The Results and Replace The Text from Column D To Column E AS You See in the Screen
thanks Alot ..with my Best Regards

 

[Excel Wizard]

Please try at
B2
=TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,C2&" H",),C2&" H",),",",REPT(" ",90)),90),1,0),0,REPT(" ",90)),90))

C2
=MID(A2,FIND("Hello",A2&"Hello"),15)

E2
=VLOOKUP(LEFT(D2,FIND(" ",D2&" ")-1),$L$2:$M$6,2,)

 

[Hany ali]

Thank you very much, my honorable teacher. You are indeed a man of genius ... and this is really what is needed
but
Maybe sometimes it is the output of the system
So

Trees Agent 00:00,Hello Park Fees H 00:00 Not Hello Park Fees H 00:00,Trees Agent 00:00 The error appears in the equation in the cell with the red background in Cell B8

 

[Excel Wizard]

Please try at B2
=SUBSTITUTE(TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(IF(C2="",A2,REPLACE(A2,FIND(C2,A2&C2),24,)),0,1),1,REPT(" ",90)),90)),",",)

 

[Hany ali]

thanks alot my dear and this is really what is needed