Split Words / Alphanumeric statements into rows for each character

[caltang]

As per the title. Here’s some sample data: 

1. Friedrich der Große

2. Jazz445566

3. Valois776633

4. 77@@omega@@77

Trying to get the delimiter right for text to columns to split into rows. Help appreciated!

[FinnCharlton · Accepted solution]

Hey @caltang , if you want to split into a new row for each character, use the RegEx tool's Tokenise option, with just . as the expression:

[PhilipMannering]

Do you mean like this @caltang ?

[caltang]

For some reason my brain kept trying the Text to Columns tool when I knew it was Regex. Thanks @FinnCharlton , this is exactly what I want! Appreciate it man.

[caltang]

Hi @PhilipMannering sorry I think my sample data might have misled you. @FinnCharlton got it right - I want it by character. I did it before but somehow forgot, this was a helpful refresher! Thanks, by the way.

[PhilipMannering · Accepted solution]

No worries. I misinterpretted. Of course if you just want characters (not spaces) you can use `\w`

[caltang]

This works too! Thanks man!

[FilipR]

[deleted]