Word search in a cell

[Closed]
Report
Posts
1
Registration date
Saturday April 4, 2015
Status
Member
Last seen
April 4, 2015
-
Hello,

In one cell i have below text:


NIPPLE, PIPE: TYPE SEAMLESS, SIZE 1/2 IN, LENGTH 100 MM, CONNECTION TE, MATERIAL CS ASTM A106, RATING SCH 160, GRADE B, STANDARD ASME B36.10/ASTM A733



With respect to above text i want to capture below abbreviation meaning in another cell, how to find?



Below are the abbreviations:-



PE Plain both ends

BE Beveled both ends

GE Grooved both ends

TE Threaded both ends

PE Plain ends

BE Beveled ends

TE Threaded ends

PBE Plain one end and beveled the other

PGE Plain one end and grooved the other

PTE Plain one end and threaded the other

BGE Beveled one end and grooved the other

BTE Beveled one end and threaded the other

GTE Grooved one end and threaded the other



Please help out

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!