This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing
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
This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing
Judith-Excel-Sharing | Sciencx (2024-09-10T03:07:54+00:00) #61 — Split Words as Individual Characters. Retrieved from https://www.scien.cx/2024/09/10/61-split-words-as-individual-characters/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.