...

Split words as individual characters

 

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

Enter the following formula in SPL XLL:

=spl("=E@1(?).conj(~.split())",A1:A3)

Picture1png

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.

Source:https://stackoverflow.com/questions/78100149/separate-letters-in-excel-from-1-column-to-different-rows


 
 •  73 View  •