| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
splitting names & email add.
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
| Splitting names | Excel Discussion (Misc queries) | |||
| Email worksheet from a list of names and email | Excel Discussion (Misc queries) | |||
| Splitting names from cells | Excel Discussion (Misc queries) | |||
| Siple but what was the formula for splitting names? | Excel Programming | |||
Threaded Mode
