Problem description & analysis:
An Excel table has a column of words:
Task: Split each of these words as individual characters and concatenate them into a column, as the following shows:
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
Top comments (1)
Some comments may only be visible to logged-in visitors. Sign in to view all comments.