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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
badass answers thanks
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?