+44 (0)785 715 1348
office@bogdans.co.uk

Currently Browsing: email

Extract clean email address from Excel 0

Posted on 5, May 2014

in Category Tutorials

This function extracts the email address from the C1 column by removing the following characters/strings: “<“, “>”, “mailto:”. Hope this helps! SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(LEFT(C1574,FIND(“@”,C1574,start-pos)−1),” “,REPT(” “,99),occurrence),99))&MID(C1574,FIND(“@”,C1574),FIND(” “,C1574&” “,FIND(“@”,C1574))−FIND(“@”,C1574)), “<“, “”), “>”, “”), “mailto:”, “”) Bogdan

Read More