Can't create a spreadsheet from a word doc?

H

hbeau

I copied into a word doc the top 929 songs from a survey taken on a
local radio station. I am interested in transfering the data (#, Title,
Artist) into an Excel spreadsheet. My problem is that the delimiters
don't apply. By this I mean that a space is not conveniently the
delimeter between a title and and artist because a title can have 2 or
more words, and the same applies to the artist. Is there a work around
for this problem?
 
G

Guest

You can probably create a table in Word and then copy your data over. See
the Help instructions in MS Word for copying tables to Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically linking data from Word into Excel 2
Creating Word docs from Excel with VBA 3
How to transfer text from Excel to Word 7
Word 07 can't make email doc without using attachments 1
Outlook 07 can't make email doc without using attachments 1
Automating Excel from Word - How to Sort a Range of Cells 6
Can't open docs from Outlook into Word or close Word without Eror 1
opening an existing word doc from an Excel VBA macro 1

Top