• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

my formula correction for bank statement desired words

GVN KUMAR

Member
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.
 

Attachments

Marcilio

New Member
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

Member
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
 
Top