#141 — Generate Continuous Arrays — Concatenate Results into a String

Problem description & analysis:

The values in columns A and B are natural numbers, representing the start and end points of the array respectively:

Task: Use the values in columns A and B to generate a string composed of a natural num…


This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing

Problem description & analysis:

The values in columns A and B are natural numbers, representing the start and end points of the array respectively:

source table

Task: Use the values in columns A and B to generate a string composed of a natural number array, and fill in the result in column C, as follows:

expected results

Solution:

Use SPL XLL and enter in cell C2:

=spl("=to(?1,?2).concat@c()",A2,B2)

code result
Then drag C2 down to every relevant row:

final results

Download esProc Desktop for FREE and boost your workflow efficiency today with SPL XLL!!! 🚀✨⬇️

SPL download address: esProc Desktop FREE Download

Plugin Installation Method: SPL XLL Installation and Configuration

References to other rich Excel operation cases: Desktop and Excel Data Processing Cases

YouTube FREE courses: SPL Programming


This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing


Print Share Comment Cite Upload Translate Updates
APA

Judith-Excel-Sharing | Sciencx (2025-02-08T03:30:42+00:00) #141 — Generate Continuous Arrays — Concatenate Results into a String. Retrieved from https://www.scien.cx/2025/02/08/141-generate-continuous-arrays-concatenate-results-into-a-string/

MLA
" » #141 — Generate Continuous Arrays — Concatenate Results into a String." Judith-Excel-Sharing | Sciencx - Saturday February 8, 2025, https://www.scien.cx/2025/02/08/141-generate-continuous-arrays-concatenate-results-into-a-string/
HARVARD
Judith-Excel-Sharing | Sciencx Saturday February 8, 2025 » #141 — Generate Continuous Arrays — Concatenate Results into a String., viewed ,<https://www.scien.cx/2025/02/08/141-generate-continuous-arrays-concatenate-results-into-a-string/>
VANCOUVER
Judith-Excel-Sharing | Sciencx - » #141 — Generate Continuous Arrays — Concatenate Results into a String. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2025/02/08/141-generate-continuous-arrays-concatenate-results-into-a-string/
CHICAGO
" » #141 — Generate Continuous Arrays — Concatenate Results into a String." Judith-Excel-Sharing | Sciencx - Accessed . https://www.scien.cx/2025/02/08/141-generate-continuous-arrays-concatenate-results-into-a-string/
IEEE
" » #141 — Generate Continuous Arrays — Concatenate Results into a String." Judith-Excel-Sharing | Sciencx [Online]. Available: https://www.scien.cx/2025/02/08/141-generate-continuous-arrays-concatenate-results-into-a-string/. [Accessed: ]
rf:citation
» #141 — Generate Continuous Arrays — Concatenate Results into a String | Judith-Excel-Sharing | Sciencx | https://www.scien.cx/2025/02/08/141-generate-continuous-arrays-concatenate-results-into-a-string/ |

Please log in to upload a file.



There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.

Related Posts