Simple Microsoft Excel Question

[dugweb]

Is there a quicker way to take a list of a place that looks like this on the internet

SOMEWHERESHOP
123 NOWHERE RD, SOME ST.
(555)555-5555

to a spreadsheet with columbs of "Name", "Address", and "Phone" in individual columbs?

Im currently using the cut and paste method :disgust:

 

[Alex]

you could use a VB script for that since the data format is virtuall all the same

go to mrexcel.com for further assistance! peace

 

[wkinney]

cat, awk, grep,
csv import to excel ?

 

[WW]

is there a blank line between each address?

put the addresses in word, and search and replace ^p^p (two returns in a row) with something like <newrecord>, then search and replace ^p with a comma...

then go back and search and replace <newrecord> with a ^p

then you have a .csv (comma separated value) file that excel can import nicely