importing a text file with addresses ... looking for an easy way

P

Pasqual

Hi !
I have read the newsgroup for the last two hours, but didn`t find a
solution.
There is a large textfile with addresses and no delimiters. Like this:

Peter Parker
2434 Parkway Dr.
Miami, Fl 23432

Ann Trump
5342 5th N
Tampa, Fl 36534

What is the easiest way to set field and record delimiters and to
import these addresses in Excel? Or is there a workaround in Word in
order to put additional
delimiters at the and of each row?
Thank you for sharing your knowledge.
Pasqual
 
F

Frank Kabel

Hi
some questions first:
- do all addresses consist of 3 rows
- what is your expected result
 
Top