Working with text can be notoriously challenging because it's often unclear how to store the data. Should you combine first and last names in the same cell? What about city and state? Often, what …
Continue Reading about How to understand the TEXTJOIN() function in Excel →