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

david angel (X)
Local time: 03:43
French to English
+ ...
Oct 16, 2009

Hi. I have a very long list of agency emails, usually in the form "person'". 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: 06:43
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

memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
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 »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search