DEV Community

Cover image for #61 — Split Words as Individual Characters
Judith-Excel-Sharing
Judith-Excel-Sharing

Posted on

#61 — Split Words as Individual Characters

Problem description & analysis:

An Excel table has a column of words:

original table
Task: Split each of these words as individual characters and concatenate them into a column, as the following shows:

desired table

Solution:

Enter the following formula in SPL XLL:
=spl("=E@1(?).conj(~.split())",A1:A3)

As shown in the picture below:

result table with code entered

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.