Hi,
I need to extract middle text in a single word.
e.g. AB00123456@abcd.com
answer will be 123456.
Any help?
Hi,
I need to extract middle text in a single word.
e.g. AB00123456@abcd.com
answer will be 123456.
Any help?
This should be shorter....But for now.
=MID(REPLACE(A1,FIND("@",A1),LEN(A1),""),MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),99)/1