Get Name From Email Address Excel Formula
First, FIND looks for the “@” character inside the email address “achang@maaker.com”. The “@” character is the 7th character so FIND returns 7. The number 1 is then subtracted from 7 to yield 6. This is done to prevent the formula from extracting the “@” along with the name. The LEFT function then extracts 6 characters from the email address, starting from the left. So: Dave Bruns Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa....