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