Find and replace plus for Excel or csv
Thread poster: david angel

david angel
Local time: 23:06
French to English
+ ...
Oct 16, 2009

Hi. I have a very long list of agency emails, usually in the form "person'sname@agencyname.com". But large numbers of people leave agencies. So I have been wondering if there is any way I can search for all items with a @ (i.e. email addresses), delete anything before the @ and substitute "info", "translation", etc. I don't have any grand text editors and probably wouldn't know how to use one if I did: does anyone, I wonder, know of a simple way?
Thanks in advance. David A.


 

Henrik Pipoyan  Identity Verified
Local time: 02:06
Member (2004)
English to Armenian
Use wildcards Oct 16, 2009

Try this. In Excel open Edit > Replace or hit Ctrl+H, in the "Find what:" filed insert *@ and in the "Replace with:" filed insert info@ or translation@. All the addresses will be replaced with info@... or translation@...

I hope this helps.


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Find and replace plus for Excel or csv

Advanced search






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search