Hi can anyone please help I have used excel for a while, but am new to macro’s. I have a large work sheet with a few thousand rows. I want to use a macro that will check each character in a row for an @ symbol if its not the @, then delete character. If it is @ move to next row down and continue checking. I hope this is clear and many thanks in anticipation to any help :-)