Hi keshavtale,
Try this formula:
Enter in G8 and copy down
Formula:=IFERROR(-LOOKUP(1,-RIGHT(LEFT(E8,MIN(SEARCH({"@","MT","M."},E8&"MT@M.")-1)),{1,2,3,4,5,6})),"")
Hi keshavtale,
Try this formula:
Enter in G8 and copy down
Formula:=IFERROR(-LOOKUP(1,-RIGHT(LEFT(E8,MIN(SEARCH({"@","MT","M."},E8&"MT@M.")-1)),{1,2,3,4,5,6})),"")
Last edited by AlKey; 04-06-2019 at 01:23 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks for solution, now my problem is solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks