Tekniska forum » Software applications »
Find and replace plus for Excel or csv
Trådens avsändare: david angel (X)
david angel (X)
david angel (X)
Local time: 17:47
Franska till Engelska
+ ...
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
Henrik Pipoyan  Identity Verified
Local time: 20:47
Medlem (2004)
Engelska till Armeniska
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:

Moderatorer för detta forum
Natalie[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

Find and replace plus for Excel or csv






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »