Problem description & analysis:
An Excel table has a column of words:
| A | |
| 1 | EJ |
| 2 | OU |
| 3 | only |
Task: Split each of these words as individual characters and concatenate them into a column, as the following shows:
| B | |
| 1 | E |
| 2 | J |
| 3 | O |
| 4 | U |
| 5 | o |
| 6 | n |
| 7 | l |
| 8 | y |
Solution:
Enter the following formula in SPL XLL:
=spl("=E@1(?).conj(~.split())",A1:A3)
As shown in the picture below:
Explanation:
E@1 converts the data range to a one-dimensional sequence. ~ represents the current member; split()splits each character from each word; conj() concatenates the characters.
The example was originally on StackOverflow. Compare the conventional solutions with the SPL approach to get the efficiency of SPL. Ready to simplify your spreadsheets?🧹✨ Check out the following links and boost your productivity today!
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