-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
chunks
-
L
Splitting a string out in a cell into 60 character chunks
Hello! I have a problem that I would like help solving if I may. I have a spreadsheet that has a cell containing a string of text. I need to split this cell into 60 character chunks, preserving whole words if at all possible. The maximum cell length I have is 240 characters so I'll need to...- laundon
- Thread
- cell characters chunks split string
- Replies: 20
- Forum: Excel Questions
-
J
Separate cell value into user specified size chunks with space seperator. How to?
I'm looking for a custom function that will take a long character string (for example: 1234ABCD5678EFGH in cell A1), and split it into chunks in column B, and have each chunk separated by spaces (but all in the same output column) with the number of characters in each chunk to be specified by...- JugglerJAF
- Thread
- cell chunk chunks output size
- Replies: 2
- Forum: Excel Questions
-
C
Need to pull oData in chunks because times out...
Excel 2013: Have 16,000 lines coming in - have found it will only pull it in 4,000 line chunks - how would you go about setting up 4 different odata connections in Power Query with ability to refresh all of them? Also if editing of columns and filters after all the data is in - any way possible...- cwolfe11
- Thread
- chunks macros odata powerquery
- Replies: 0
- Forum: Power Tools
