If you have a long list of email addresses that you are wanting to send a message to, it can be difficult to near impossible to copy and paste them one by one into an email. But today, we are going to walk through a simple Excel function that will make the process of combining all of those email addresses into one line much more simple. Let’s take a look. This might seem tricky at first, but trust me, it’s super simple and only takes a moment. First, click into the cell next to the email addresses you want to combine. Then type equal text join followed by a parenthesis. Add quotation marks and then insert a semicolon followed by another quotation mark and a comma. Now you are going to want to type either true or false. You are going to use true more often. This means if there is a blank space or cell to simply ignore it. If you type false, it will include a blank space in your final output. Now add another comma and select the email addresses that you want to combine. And then another parenthesis and enter. Look how easy. Now you have your email ready list of addresses to copy and paste. To eliminate the chance of error when copying and pasting, right click and select copy. Go into another cell, right click, and click paste values. Now you are all set to copy and paste this again into an email. And there you go. You have your long list of email addresses copied and pasted perfectly into an email. I told you it was simple. This is a helpful shortcut with a ton of practical uses. Please note that depending on your email server, you may need to insert a comma instead of a semi-colon.