Identify Special Character

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

Help

Accepted answers

Please see my example below:

@Mohini79 I'd approach it like this:

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

Please see my example below:

@Mohini79 I'd approach it like this:

Appreciated your help.