Michele Morrow
New Member
Members
Power Query
Power Pivot
Xtreme Pivot Tables
Power Query
Power Pivot
Xtreme Pivot Tables
Forum Posts: 2
Member Since:
November 29, 2020
November 29, 2020
Offline
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!
Mynda Treacy
Admin
Forum Posts: 4703
Member Since:
July 16, 2010
July 16, 2010
Offline
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
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 287
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Nicole White
Adrian Macleod
Ed Norris
manoj Ka
Chris Cowan
Pawel Ganczarski
Molly King
Faraz Rafi
Anthony Blake
Jackb57
Forum Stats:
Groups: 3
Forums: 24
Topics: 6873
Posts: 30127
Member Stats:
Guest Posters: 49
Members: 33678
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —