paulselman
New Member
- Joined
- May 3, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi, I hope someone can help me...
I am using Excel to prepare some data for an automated service to do mass deletions from a system
I have a list with circa 150000 references on it. I have to create a single cell with a maximum of 25000 characters in it and each individual reference has to be separated by a semicolon
The data looks something like this
I need to combine a maximum of 4000 cells in a row of reference numbers with semicolon as above but in order for the system that will take in the data to work the cell with the result of the concat must have no more than 25000 characters.
I am looking for a way to prepare the data based on that criteria for the entire column that contains 150000 rows so that I end up with a series of rows that I can just paste onto the next system. I have used CONCAT but dragging this down does not increment as I need it to
Thanks in advance
I am using Excel to prepare some data for an automated service to do mass deletions from a system
I have a list with circa 150000 references on it. I have to create a single cell with a maximum of 25000 characters in it and each individual reference has to be separated by a semicolon
The data looks something like this
18045; |
18152; |
18154; |
18157; |
18161; |
I need to combine a maximum of 4000 cells in a row of reference numbers with semicolon as above but in order for the system that will take in the data to work the cell with the result of the concat must have no more than 25000 characters.
I am looking for a way to prepare the data based on that criteria for the entire column that contains 150000 rows so that I end up with a series of rows that I can just paste onto the next system. I have used CONCAT but dragging this down does not increment as I need it to
Thanks in advance