Hi All:
In the current column is the data I pull. The second column extracts text from it. Can someone please show me a formula that I can put in the desired column that will produce the result desired.
Current Desired
0107-01 - TLEU_Dec 06 TLEU
0207-01 - 441ZZ1_TLEU_Feb 07 TLEU
36-0107-02 - VIJE_Dec 06 VIJE
0207-01 - 441ZZ1_TLEU_Feb 07 TLEU
0407-01 - TLEU_Svcs Fee TLEU
0207-02 - 441ZZ2_VIJE - Feb 07 VIJE
0307-01 - TLEU_Feb 07 TLEU
0307-02 - VIJE_Feb 07 VIJE
0407-02 - VIJE_Svcs Fee VIJE
0507-01 - TLEU_Apr 07 TLEU
0507-02 - VIJE_Apr 07 VIJE
0607-01 - TLEU_ZZ1 TLEU
Basically I want to extract VIJE and TLEU from the long text.
In the current column is the data I pull. The second column extracts text from it. Can someone please show me a formula that I can put in the desired column that will produce the result desired.
Current Desired
0107-01 - TLEU_Dec 06 TLEU
0207-01 - 441ZZ1_TLEU_Feb 07 TLEU
36-0107-02 - VIJE_Dec 06 VIJE
0207-01 - 441ZZ1_TLEU_Feb 07 TLEU
0407-01 - TLEU_Svcs Fee TLEU
0207-02 - 441ZZ2_VIJE - Feb 07 VIJE
0307-01 - TLEU_Feb 07 TLEU
0307-02 - VIJE_Feb 07 VIJE
0407-02 - VIJE_Svcs Fee VIJE
0507-01 - TLEU_Apr 07 TLEU
0507-02 - VIJE_Apr 07 VIJE
0607-01 - TLEU_ZZ1 TLEU
Basically I want to extract VIJE and TLEU from the long text.
Last edited: