Split String to characters, Special characters and Numbers

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

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

1 Like

@Santhi

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

Sure

@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.

5 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.