There are lots of ways to combine cells in Excel or Google Sheets. TEXTJOIN is a newer function and is a bit more flexible than some other options since you have the ability to skip over blank cells and you can easily put a delimiter between each cell.Other options to combine cells include using the CONCAT or CONCATENATE functions, using the & between cell references, or using Flash Fill to have Excel combine data base on the pattern it detects.#excel #workhacks #googlesheets | Spreadsheet Natio

Combine data from multiple tabs easily with the VSTACK function! Just type VSTACK in a cell, select your ranges across tabs, and press Enter. Your data will be seamlessly merged. Share this tip and follow for more handy spreadsheet tricks! #Excel #exceltips #exceltutorial #exceltricks #msexceltraining | Marcus Andreno