Let's say that you work at one of those companies that has a nice leftover-from-the-8-character-file-name-limit-days email format. Solveig Haugland becomes shauglan, Bob Nelson becomes bnelson, and so on.
And let's also say, as long as we're dreaming up situations, that you've got a spreadsheet full of first and last names but you don't have their emails.
You could type in all the email addresses but even an intern who's paid well by the hour is going to balk at that.
The faster way is to use CONCATENATE and LEFT.
You've got this.
You want this.
Here's how to get it.