Hi. I have a list of over 10,000 customers in an excel spread sheet. About 500 them unsubscribed to email but willing to receive normal paper mail.
How do I go about deleting their email address only quickly without having to use Ctrl+F and replace one at a time?
Thanks
Hi guru420
Are the 500 flagged in any way?
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
hi, guru420, select column in question, [Ctrl+F], What: "*@*", Replacement: "". It replaces all the cells that have @ sign in string
Last edited by watersev; 09-23-2011 at 02:03 PM.
@ watersev
Won't that affect all 10,000?
@jaslake
I did miss that part, it will effect all of them
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks