Split String to characters, Special characters and Numbers

[Santhi]

Hiii everyone,
I’m having some list of data in excel sheet. I need split Sprat from Characters ,Numbers and special characters.
Example:

I need Output like that:
AAAAAAA a gmail com 89 . @ .
BBBBB k gmail com 82 . @ .

[lakshman (Ganta lakshman)]

@Santhi

Could you please show me sample data are you trying to split it. Then we can help you better in this.

[Santhi]

Sure

[lakshman (Ganta lakshman)]

@Santhi

use regular expressions to retrieve those characters.

[A-Za-z] - to retrieve alphabetics from given string

[0-9] - to retrieve numbers from given string

[^\w*] - to find special Characters

You can test these regular expressions here.

regex101: build, test, and debug regex