textjoin function

5 Functions to Instantly Clean Up Messy Excel Spreadsheets
a messy excel spreadsheet can be a nightmare — extra whitespace, inconsistent formatting, text all over the place. but with the right functions, you can clean it up in seconds and make your data actually useful.
CONCAT vs. TEXTJOIN: Which function should I choose to concatenate data?
both concat and textjoin help you to concatenate data in different cells. let's learn how to use tipsmake.com.com, the difference between them to see which function you should choose to join the data!