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

david angel (X)
Local time: 20:53
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: 00:53
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






SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »
WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »



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