We can remove unwanted character like @, #... select -->Column--> Go to Data Tab--> Select Text To column function it will work