Link to home
Start Free TrialLog in
Avatar of finnstone
finnstone

asked on

concatenate 6k cells - automate creating the formula

how can i create a concatenate formula to combine the contents of 6k cells

i would rather not type each cell number separated by a comma!
but a range does not work either

how can i create a list of all those cells?
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
With Excel 2016 you also get the CONCAT function. Syntax and use from office Support shown here:

https://support.office.com/en-gb/article/CONCAT-function-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2

Both CONCAT and TEXTJOIN have a limitation of 32,767 characters for the resulting string; so that gives you an average of just over 5 characters per cell if looking at 6000 cells. Will that be enough?
Avatar of finnstone
finnstone

ASKER

badass answers thanks