I have a bunch of rows of data. I want to separate the rows that contain the symbol "@" from the rows that don't have that symbol. Right now I'm cutting and pasting the rows with the symbol "@" into a separate sheet on Excel, then putting together the remaining rows which don't have that symbol on the original sheet (via cut and paste aswell). This is taking quite a while.
Is there a way or function on Excel that can identify the rows with the symbol "@" and automatically put them togther/separate them from the rows which don't have th symbol "@" in them?
If anyone can come up with a solution I would be moe than greatful
Thanks
Stephen
Bookmarks