Jumat73Copper ContributorMay 08, 2024Need help to auto fill dataPlease help to auto fill data from many columns to 1 column as below.
1 ReplyReplies sorted by NewestHarun24HRBronze ContributorMay 08, 2024Jumat73 You need TEXTJOIN() function. Try-=TEXTJOIN("-",1,A2:E2) textjoin.xlsx9 KB
Harun24HRBronze ContributorMay 08, 2024Jumat73 You need TEXTJOIN() function. Try-=TEXTJOIN("-",1,A2:E2) textjoin.xlsx9 KB