Identify Special Character

[Mohini79]

Hi,

I have one column called name in which there are certain cell which contain special character ( * , # ,@,).

I want to identify which special characters are there and bring it into one new column against those cell's.

Please confirm for any tool or formula to get the result

Also suggest further how to remove this characters

Thanks in ad

[martinding]

Hi @Mohini79 ,

This is a job for the RegEx Tool, you can use "Parse" (within the RegEx Tool) to bring the special characters to a new column.

You can also use Replace (within the RegEx tool) to replace those special characters with blank "".

[martinding · Accepted solution]

Please see my example below:

[BS_THE_ANALYST · Accepted solution]

@Mohini79 I'd approach it like this:

[Mohini79]

Appreciated your help.