Hi Experts,
I have data that runs in columns as:
SYD MH X/KUL MH DEL213.49/-BOM MH X/KUL MH SYD213.49NUC426.98
SYD MH X/KUL MH DEL213.49/-BOM MH X/KUL MH SYD213.49NUC426.98
SYD MH KUL MH BOM213.49MH X/KUL MH SYD213.49NUC426.98
SYD MH KUL MH BOM213.49MH X/KUL MH SYD213.49NUC426.98
SYD MH KUL MH BOM160.11MH X/KUL MH SYD160.11NUC320.22
MEL MH X/KUL MH BOM252.31MH KUL MH MEL252.31NUC504.62
Looking for simple function to extract only "BOM" three letter word.
Extract word will not exceed 3 letters and target word in each cell will be somewhere but three letters only
Thanks in advance,
Karnik
Bookmarks