Jumat73Copper ContributorMay 09, 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 09, 2024Jumat73 You need TEXTJOIN() function. Try-=TEXTJOIN("-",1,A2:E2) textjoin.xlsx9 KB
Harun24HRBronze ContributorMay 09, 2024Jumat73 You need TEXTJOIN() function. Try-=TEXTJOIN("-",1,A2:E2) textjoin.xlsx9 KB