Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
170
Views
Topic starter
Hello,
I am using Textjoin function to combine numbers that are in 123 cells into one cell.
My results only return the first 115 cells.
How can I include all 123 cells into the one cell?
Version: Excel Microsoft 365
Thank you!
Posted : 29/03/2022 7:59 pm
Hi Michelle,
Welcome to our forum! The TEXTJOIN formula is joining all characters, it's just that it can't display them all in the one cell without wrapping the text and merging and centering the data across several columns. See file attached.
BTW, you can use a single formula that references column A like so:
=CHAR(34)&TEXTJOIN({""","""},1,A1:A124)&CHAR(34)
Hope that helps.
Mynda
Posted : 29/03/2022 10:08 pm
Topic starter
Thank you very much Mynda. I appreciate your help!
Posted : 30/03/2022 7:31 am
