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
Solved! Go to Solution.
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 "".
Appreciated your help.