#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 number array, and fill in the result in column C, as follows: Solution: Use SPL XLL and enter in cell C2: =spl("=to(?1,?2).concat@c()",A2,B2) Then drag C2 down to every relevant row: Download esProc Desktop for FREE and boost your workflow efficiency today with SPL XLL!!!
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 number array, and fill in the result in column C, as follows:
Solution:
Use SPL XLL and enter in cell C2:
=spl("=to(?1,?2).concat@c()",A2,B2)
Then drag C2 down to every relevant row:
Download esProc Desktop for FREE and boost your workflow efficiency today with SPL XLL!!!
