Notifications
Clear all
Topic starter
Hello,
I’m trying to join two cells (Column A and Column B) into Column C using TEXTJOIN. In that some of the cells in Column B are blank, I need a formula that recognizes these blank cells and only captures the text in Column A and without referencing the delimiter.
The formula I tried (IF(b2=” “,a2, TEXTJOIN(“/”,TRUE,a2:b2))) doesn’t work.
Can you help? Thank you.
Posted : 17/03/2022 8:54 pm
Hi M K,
What do you mean 'it doesn't work'? You don't get the result you want? You have an error message?
Here is an example on the sheet 'Sheet2'.
BR,
Lionel
Posted : 18/03/2022 1:38 am
TEXTJOIN already has the option to ignore blank cells, so just:
=TEXTJOIN("/",TRUE,a2:b2)
should work.
Posted : 18/03/2022 5:28 am
Topic starter
Thank you!
Posted : 18/03/2022 8:55 pm
