Using a text function, such as CONCAT, TEXTJOIN, or just the $"$ & $",$ combine the first and last name into the corresponding cell in column N$.$ Make sure the first and last name is separated with a space

You will earn points as long as you don't hard code and you use ANY TEXT function... Refer to Excel Ninja for hints!

The addresses in column $R$ are in all caps. Use an Excel function so that only the first letter in each word is capitalized while the remaining letters are lowercase using column $S.$

Using the LEFT function, pull the area code of each phone number from column $T$ to column $U.$