Word to Excel List

K

Ken Lempka

I have a very long list of names in Word, each name separated by a ";". How
do I turn it into a list in Excel with each name in a cell without doing it
one name at a time?
 
N

Nikki

select data....text to column.....Delimited...next...put a check mark in
semicolon ( remove all orther check marks)..next...finish

hope it helps.

N
 
J

JMay

Do a rountine Copy (from Word) switch to Excel - Click in a Cell (A1, say)
Edit, Paste.

Select A1 to A? (Last non-blank row) - Data, TextToColumns...
Delimeted; Select Semicolon; Text Finish
Done
 
S

Sheeloo

Replace ; by a Paragraph Mark in Word (in Find/Replace dialog click on More,
Click on Special and choose Paragraph Mark [or type ^p directly])
Select the names and paste in Excel...
 
K

Ken Lempka

Thanks. This gave me text to columns but I needed text to rows. A technique
for another time, though.
 
K

Ken Lempka

This is exactly what I needed. Thanks.

Sheeloo said:
Replace ; by a Paragraph Mark in Word (in Find/Replace dialog click on More,
Click on Special and choose Paragraph Mark [or type ^p directly])
Select the names and paste in Excel...

--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


Ken Lempka said:
I have a very long list of names in Word, each name separated by a ";". How
do I turn it into a list in Excel with each name in a cell without doing it
one name at a time?
Click to expand...
Click to expand...
 
Top