removing names and phone numbers

tomwilpro

Banned - Selling via PM
Joined
Apr 27, 2021
Messages
368
Reaction score
60
is there any way to remove all the names and phone numbers leaving just the emials from a doc of say like 10k contacts or more, as ive tried removing bulk names and numbers in docs excel and some other doc editors inlcuding micro word wordpad, and tried some online stuff but cannnot remove all the names and phone numbers only all at once.

Is there something you've used to help with this just something where it can select something specific like all the names and phone number and remove them all at once, just leaving the emails?
 
Of course you can do it with excel easily. I suggest you do "find and replace" feature..
 
is there any way to remove all the names and phone numbers leaving just the emials from a doc of say like 10k contacts or more, as ive tried removing bulk names and numbers in docs excel and some other doc editors inlcuding micro word wordpad, and tried some online stuff but cannnot remove all the names and phone numbers only all at once.

Is there something you've used to help with this just something where it can select something specific like all the names and phone number and remove them all at once, just leaving the emails?

How are they formatted? And what file extension is the file?

Share the format here and I'll tell you how to clean the file.
 
yeah you can with [ find and replace ] feature.
 
You can use Excel extensions. Many free extensions can help you calculate most complex formulas
 
How is the data formatted currently?
 
Select all expressions with @ (emails), then remove all (names, phones, emails), then insert emails again.
What he said, except, back-up your file lol
Here's how to work with RegExp in Excel and the regular expression that will do the job in .NET should be:
Code:
^[^@\s]+@[^@\s]+\.[^@\s]+$
Please verify whether it works before wrecking your doc. The regex was proudly stolen from Microsoft's website.
 
no ive tried the find and replace it doesnt allow me to remove just replace it with someting else, but i just need it removed only
 
Back
Top