M
Manov Saypuri
Hi All
In each row of sheet, I have text filled in Col A, B, C and D. I am
looking to write a formula to search for pattern which matches BIS-DI-
eBDR-0003-1.0.0 from A1 to D1 and paste the result in Column i.e, E1.
I have about 30,000 rows of similar data and looking for a pattern to
match BIS-DI-eBDR-0003-1.0.0
BIS- Non numeric (3 letters)
DI- Non numeric (2 letters)
eBDR- Non numeric (4 letters)
0003- Numeric (4 numbers)
1. Numeric ( 1 number)
0. Numeric ( 1 number)
0 Numeric ( 1 number)
Column A Column
B Column C Column D Column E
BIS-DI-eBDR-0003-1.0.0.DOC ghdrht
rgergerg hwestgw
rfgreag BIS-DI-eBDR-0003-1.1.0.DOC
rgergerg rtrwe
erggqrehg ergrg BIS-DI-eBDR-0017-1.0.0.DOC 54yy5.ouu
fdrty
BIS-DI-eBDR-0018-1.0.0.doc erqggg
rrg het5
In each row of sheet, I have text filled in Col A, B, C and D. I am
looking to write a formula to search for pattern which matches BIS-DI-
eBDR-0003-1.0.0 from A1 to D1 and paste the result in Column i.e, E1.
I have about 30,000 rows of similar data and looking for a pattern to
match BIS-DI-eBDR-0003-1.0.0
BIS- Non numeric (3 letters)
DI- Non numeric (2 letters)
eBDR- Non numeric (4 letters)
0003- Numeric (4 numbers)
1. Numeric ( 1 number)
0. Numeric ( 1 number)
0 Numeric ( 1 number)
Column A Column
B Column C Column D Column E
BIS-DI-eBDR-0003-1.0.0.DOC ghdrht
rgergerg hwestgw
rfgreag BIS-DI-eBDR-0003-1.1.0.DOC
rgergerg rtrwe
erggqrehg ergrg BIS-DI-eBDR-0017-1.0.0.DOC 54yy5.ouu
fdrty
BIS-DI-eBDR-0018-1.0.0.doc erqggg
rrg het5