Log In
Register
Home
TEXTJOIN with blank cells
M K
Active Member
Members
Forum Posts: 4
Member Since:
January 17, 2022
January 17, 2022
Offline1
March 17, 2022 - 10:54 am
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.
Lionel Baijot
Member
Members
Forum Posts: 114
Member Since:
September 9, 2020
September 9, 2020
Offline2
March 17, 2022 - 3:38 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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Ngoc Tinh
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
michael serna
mashal sana
Tiffany Kang
Leah Gillmore
Sopi Yuniarti
LAFONSO HERNANDEZ
Hayden Hao
Angela chen
Sean Moore
John Chisholm
Forum Stats:
Groups: 3
Forums: 24
Topics: 6215
Posts: 27248
Member Stats:
Guest Posters: 49
Members: 31897
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —