Lots of ways to combine cells. #excel #workhacks | Spreadsheet Nation

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