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
adam kenny
....
...
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
-----------------
Hope experts could remind me the way.
Sincerely