I have imported an email list into excel and some of the emails have the end cut off and end in .co instead of .com is there a way to do a find and replace of these? It seems like a standard search comes back with .co and .com and can't be changed
Thanks,
Neal
Welcome to the forums. You could use the find and replace feature in excel. Press and hold CTRL + F then click tab replace, under find what you could type .co and under replace with you could type .com
Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.
Doing a FIND and Replace on .co will also replace the .co inside .com so you'll end up with .comm.
First do a find replace on .com (with something unique ie. replace with ^
then do the find replace .co with .com
then go back and replace ^ with .com
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Ya or you could just change the .com's to .co's and then change the .co's to .com's.Originally Posted by ChemistB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks