TEXTJOIN Formula: Quick Tip in Microsoft Excel
Вставка
- Опубліковано 11 вер 2024
- Tired of manually combining text? TEXTJOIN to the rescue. Learn how to automate this common, repetitive task in seconds 🦸🏻
#textjoin #combinedata #exceltips #timesavingtricks #excelformatting #productivity hack.
Such a great new function! Too bad it doesn't play well with BYROW. Sometimes it works under circumstances i have yet to fully determine, but mostly they're incompatible. But, if you have TEXTJOIN external to a table and use s structured reference to the columns, works fine with BYROW. But range specification, pretty much forget it. (Again, no rhyme or reason why it very occasionally works but rarely).
❤❤
Tq
what is diffrent this function with concat