Copy Specific Value from the text

[rchure]

Hi Team,

I wanted to copy specific value from the text.

In attached file I have highlighted value which need to copy and pasted in "column C & D"

So after "invoice" and before "dt" whatever value in Text column should be copy to column "C (Invoice)" and after "dt" value copy to column "D (Date)".

Thanks,
Rahul

[Special-K]

in C4
=MID(E4,FIND("as per invoice",E4)+15,(FIND(" dt ",E4)-FIND("as per invoice",E4)-15))
and
in D4
=RIGHT(E4,LEN(E4)-FIND(" dt ",E4)-3)+0
format column D as date

[rchure]

Thank You so much!!!