Finally, you can combine SEARCH and LEFT to isolate the username of the email address. SEARCH tells you where the $"$@$"$ symbol is located and LEFT needs to know how many characters on the left you want to keep; which SEARCH can provide. Try combining SEARCH and LEFT in cell D$13$ to isolate the email username from cell C$13.$

Note: there is one slight modification you will need to make to the SEARCH part of the formula to get just the username. See if you can figure it out.

Split off username from email address. Hint: search for @ symbol: