Hi,
I am trying to clean a list of emails in Excel and running into a few problems. The list looks like this.
alan@123.co.ukalan@123.co.uk
csalva@abcinc.comcsalva@abcinc.com
jsimson@123.co.ukjsimson@123.co.uk
darren.brown@dcl.uk.comdarren.brown@dc...
lutech@gb.abb.comlutech@gb.abb.com
frank.craig@darc-group.comfrank.craig@...
frank.craig@darc-group.comfrank.craig@...
admin@ges.co.ukadmin@ges.co.uk
Each email is repeated with no spaces between them and they contain different domain names such as .net, .co.uk, .com, .com.au.
Is there an easy way to clean it so just one email appears on each line.
Thank you,
Brad
Is there a way to clean up this list in Excel?
L B has a good idea, but I think it would be easier to do with formulas.
For example, let's say your doubled addresses are in column A, starting at A2.
This formula will extract the first of the duplicate addresses:
=LEFT(A2, LEN(A2)/2)
Copy this as far down as there is data in column A.
You may want to then convert the formulas to values, so you can delete the original duplicate list. To do this, select the column with the formulas, edit-copy, and edit-paste special-values.
If you need more info, add more detail or e-mail.
Good luck.
_____
EDIT:
I'm not sure I understand, can you elaborate, like where is the "<table id="? If you like you can email your file (or a sample from it) to aladou2@yahoo.com and I'd be happy to take a look.
.
Is there a way to clean up this list in Excel?
The only thing that I can think of it to write a little VBA macro which reads the whole string, determines the length of the string, and then inserts a delimiter character at the halfway point of the string. Keep it real simple and focused on this particular problem and it should not take you very long. Then it will be easy to separate the emails into separate columns in Excel
