<h2 id="heading-problem-description-amp-analysis">Problem description &amp; analysis:</h2>
The values in columns A and B are natural numbers, representing the start and end points of the array respectively:
<img src="https://miro.medium.com/v2/resize:fit:790/0*qeMbgt6TiO4T2g47.png" alt />
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:
<img src="https://miro.medium.com/v2/resize:fit:784/0*EvGASbol2lgk7Wpx.png" alt />
<h2 id="heading-solution">Solution:</h2>
Use SPL XLL and enter in cell C2:
<pre><code class="lang-plaintext">=spl("=to(?1,?2).concat@c()",A2,B2)
</code></pre>
<img src="https://miro.medium.com/v2/resize:fit:796/0*tgxl6E-81bgLRDF7.png" alt />
Then drag C2 down to every relevant row:
<img src="https://miro.medium.com/v2/resize:fit:832/0*AAD-na2DCRx6zejP.png" alt />
<hr />
Download esProc Desktop for FREE and instantly reshape your data with SPL XLL!!! 🚀✨⬇️
SPL download address: <a target="_blank" href="https://www.esproc.com/download-desktop/">esProc Desktop FREE Download</a>
Plugin Installation Method: <a target="_blank" href="https://c.scudata.com/article/1652061135502">SPL XLL Installation and Configuration</a>
References to other rich Excel operation cases: <a target="_blank" href="https://www.scudata.com/html/Desktop-and-Excel-Data-Processing-Cases.html">Desktop and Excel Data Processing Cases</a>
YouTube FREE courses: <a target="_blank" href="https://www.youtube.com/playlist?list=PLQeR-IhHo7qNCw6o7PW8YfHvRx8pgzZso">SPL Programming</a>

## **Problem description & analysis:**

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

![](https://miro.medium.com/v2/resize:fit:790/0*qeMbgt6TiO4T2g47.png align="left")

**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:

![](https://miro.medium.com/v2/resize:fit:784/0*EvGASbol2lgk7Wpx.png align="left")

## **Solution:**

Use **SPL XLL** and enter in cell C2:

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

![](https://miro.medium.com/v2/resize:fit:796/0*tgxl6E-81bgLRDF7.png align="left")

Then drag C2 down to every relevant row:

![](https://miro.medium.com/v2/resize:fit:832/0*AAD-na2DCRx6zejP.png align="left")

---

Download **esProc Desktop** for FREE and instantly reshape your data with **SPL XLL**!!! 🚀✨⬇️

SPL download address: [esProc Desktop FREE Download](https://www.esproc.com/download-desktop/)

Plugin Installation Method: [SPL XLL Installation and Configuration](https://c.scudata.com/article/1652061135502)

References to other rich Excel operation cases: [Desktop and Excel Data Processing Cases](https://www.scudata.com/html/Desktop-and-Excel-Data-Processing-Cases.html)

YouTube FREE courses: [SPL Programming](https://www.youtube.com/playlist?list=PLQeR-IhHo7qNCw6o7PW8YfHvRx8pgzZso)

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

Problem description & analysis:

Solution: