my formula correction for bank statement desired words

[GVN KUMAR]

Sir
I am copying a formula for my requirement purpose, this a formula with your forums answers.

have regularly used this excel formula for my accounting work purpose.

This time not working this problem sir.

please could you small correct this problem sir.

 

[Marcilio]

GVN KUMAR, Good morning.

Your data has no pattern for a formula to work directly.
Please, explain to us what is your real need for results in these cases.

Below I show 8 examples of your data.
Please, what would be the result expected by you?

1) I-W CHQ RETURN-MICR-CHITRA TEXTILES

2) CHQ PAID-MICR CTS-MU-MAA SHAKTI TEXTILES

3) FT - DR - 50200010976669 - MADRAS COTTON

4) NEFT DR-ICIC0000052-PRIYA TEX-ONGOLE-N26

5) NEFT DR-KKBK0000876-MILLENNIUM-NETBANK,

6) 50200010976669-TPT-"

7) NEFT DR-YESB0ASCB05-VEER TEX-NETBANK, MU

8) NEFT DR-YESB0ASCB02-CHOICE ENTERPRISES-N

I hope it helps.

 

[GVN KUMAR]

Sir
thank you sir for your suggestions
my real need only last words sir CHITRA TEXTILES every line sir
its company name for find to which company to pay

any suggestion sir