Break a word in rows

[Jean-Balteryx]

Hello everybody !

I'm looking to break a word in rows, one letter per row.

Example :

1	Word
2	Joy
3	Herb

This would become :

1	W
1	o
1	r
1	d
2	J
2	o
2	y
3	H
3	e
3	r
3	b

I can't do it using the Text to Column tool as I have to specify a delimiter.

Do you have any idea ?

Thanks for your answers.

Jean-Baptiste

[rkapoor · Accepted solution]

@Jean-Balteryx 

Have a look at the attached sample workflow.

[JoeS]

Nice work @rkapoor 

You could also use a full stop/period. This in regex means any character, so will split not only your letter A-Z but spaces and numbers too

[Jean-Balteryx]

@rkapoor Thank you very much ! 

[Jean-Balteryx]

@JoeS Thank you for your advice !

[mattnason]

Spoiler