Description
Need to combine multiple columns into one address in Excel?
Use the TEXTJOIN function to combine text with commas and spaces, automatically skipping blank cells.
Simply set ignore_empty to TRUE, select your cells, and let Excel do the rest.
A simple Excel formula that saves time and keeps your data clean, without relying on long formulas using ampersands!
Follow @Computergaga for more practical Excel tips and tricks.
#exceltips #excelfunctions #microsoftexcel #excelformulas #exceltutorial #textjoin
