Spreadsheet: 538937d1505901245-find-a-word-and-extract-strings-with-next-20-charactors-to-a-cell-find-and-extract-a-string
Sheet: Sheet1

COMPANY CODE | BRANCH CODE | LOCATION CODE | ACCOUNT CODE | SUBLEDGER CODE | CUSTOMER NAME | SALESMAN NAME | JOB NO | DOCUMENT NO | DOCUMENT DATE | PRS SHIPPER NAME | [NAME] | CURRENCY CODE | CURRENCY AMOUNT | CURRENCY BALANCE AMOUNT | LOCAL AMOUNT | BALANCE AMOUNT | DR CR | DUE DAYS | Result
TLS | AE | 21611 | [PHONE] | C003751 | THREE LINE OLT DIV |  | LX-[PHONE]-1 | 156-CRJ-[PHONE] | 29-Dec-2016 |  | OLT-INV-61221620391_AED 3605_LX-170121610022_jm_I-OLT-INV-[PHONE]-AED 3605-29-DEC-16 | AED | -3605 | -3605 | -3605 | -3605 | C | 263 |  | <---- I like to excel to find WORD "OLT" From column "L" and bring string of 20 characters / numbers to respective column "T"
TLS | AE | 21611 | [PHONE] | C003751 | THREE LINE OLT DIV |  | LX-[PHONE]-1 | 156-CRJ-[PHONE] | 06-Nov-2016 |  | OLT-61021620284_AED 5000_LX-161021610009I-[PHONE]-AED 5000-06-NOV-16 | AED | -5000 | -5000 | -5000 | -5000 | C | 316 |  | <---- I like to excel to find WORD "OLT" From column "L" and bring string of 20 characters / numbers to respective column "T"
TLS | AE | 21611 | [PHONE] | C003751 | THREE LINE OLT DIV |  | LX-[PHONE]-1 | 156-CRJ-[PHONE] | 22-Oct-2016 |  | 61021620157_AED 4970_LX-161021610003I-OLT-[PHONE]-AED 4970-22-OCT-16 | AED | -4970 | -4970 | -4970 | -4970 | C | 331 |  | <---- I like to excel to find WORD "OLT" From column "L" and bring string of 20 characters / numbers to respective column "T"
TLS | AE | 21611 | [PHONE] | C003751 | THREE LINE OLT DIV |  | LX-[PHONE]-1 | 156-CRJ-[PHONE] | 10-Oct-2016 |  | 60921620235_AED 3810.50_LX-160821610014I-[PHONE]-AED 3810.5-10-OCT-16 | AED | -3810.5 | -3310.5 | -3810.5 | -3310.5 | C | 343 |  | <---- I like to excel to find WORD "OLT" From column "L" and bring string of 20 characters / numbers to respective column "T"
TLS | AE | 21611 | [PHONE] | C003751 | THREE LINE OLT DIV |  | LX-[PHONE]-1 | 156-CRJ-[PHONE] | 09-Oct-2016 |  | 61021620071_AED 5070_LX-161021610001I-[PHONE]-AED 5070-09-OCT-16 | AED | -5070 | -4970 | -5070 | -4970 | C | 344 |  | <---- I like to excel to find WORD "OLT" From column "L" and bring string of 20 characters / numbers to respective column "T"
TLS | AE | 21611 | [PHONE] | C003751 | THREE LINE OLT DIV |  | -- | 156-CRJ-[PHONE] | 22-Nov-2016 |  | OLT INV_61121620226_AED 9356 ( LX-[PHONE] - AED 2666) ( LX-[PHONE] - AED 2916) (LX-[PHONE] - AED 2168 ) ( LX-[PHONE] - AED 1606)I-[PHONE]-AED 9356-22-NOV-16 | AED | -9356 | -9356 | -9356 | -9356 | C | 300 |  | <---- I like to excel to find WORD "OLT" From column "L" and bring string of 20 characters / numbers to respective column "T"
TLS | AE | 21611 | [PHONE] | C003751 | THREE LINE OLT DIV |  | LX-[PHONE]-1 | 156-CRJ-[PHONE] | 09-Aug-2017 |  | OLT-70621620138_AED7910_LX-170721610034_JACQI-OLT-[PHONE]-AED 7910-09-AUG-17 | AED | -7910 | -7410 | -7910 | -7410 | C | 40 |  | <---- I like to excel to find WORD "OLT" From column "L" and bring string of 20 characters / numbers to respective column "T"
TLS | AE | 21611 | [PHONE] | C003751 | THREE LINE OLT DIV |  | LX-[PHONE]-1 | 156-CRJ-[PHONE] | 18-Mar-2017 |  | OLT-70321620172_AED3230_LX-170321610021I-OLT-INV-[PHONE]-AED 3230-18-MAR-17 | AED | -3230 | -3230 | -3230 | -3230 | C | 184 |  | <---- I like to excel to find WORD "OLT" From column "L" and bring string of 20 characters / numbers to respective column "T"