splitting names & email add.

C

Cheker

Hi,

I remember reading a code for splitting names and email addresses from a
*.txt file using (via importing) excel. But forget the content...

The source *.txt file is in the format such as:
----------------------------------------
marry chris [email protected]
adam kenny [email protected]
....
...
etc

I need to split the two info into two adjacent columns such as:
column 1 having the name & surname info ONLY
column 2 having the email address info ONLY
 
C

Cheker

Hi Norman,
Probably there is something wrong with the coding.
It is cutting and pasting names (without surnames) to column A, while
putting just a live (?) "mailto:" text to column B without any email
address info.
p.s.: I copy pasted the whole text list to column A beforehand...
Sincerely
 
C

Cheker

Hi Norman,
I know that I am taking too much of your time but this new version seems to
scan the whole list (there is a fast flicker on the screen when the macro is
executed), but finishes the macro with the "last" item display splitted on
the worksheet.
TIA
Checker
 
C

Cheker

Hi Norman,
Maybe the code is confused by some characters included in column A data.
Because when I reduced the size and delete records including characters that
are not present in Latin alphabet the code split "some" of the data
correctly. Thus I think I should concentrate more on the list. Thanks for
answering my questions step by step.
Regards
 
C

Cheker

Hi Norman,
I think You are right about the data format. It is a long list and some have
more then two spaces...I cleaned a relatively small part of it and try to
run the macro for that list. Worked OK.
Thanks a lot.
 
Top