
Michele Morrow
New Member
Members
Power Query
Power Query

Forum Posts: 2
Member Since:
November 29, 2020
November 29, 2020

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: 4620
Member Since:
July 16, 2010
July 16, 2010

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: Sameh Alami, Pam Baillie
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 188
Newest Members:
JUDY MLL
Scot Bailey
Kate Dyka
Kwaje Alfred Mogga
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Forum Stats:
Groups: 3
Forums: 24
Topics: 6548
Posts: 28672
Member Stats:
Guest Posters: 49
Members: 32834
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
