splitting names & email add.

  • Thread starter Thread starter Cheker
  • Start date Start date
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 (e-mail address removed)
adam kenny (e-mail address removed)
....
...
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
 
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
 
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
 
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
 
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.
 
Back
Top