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?
 
J

JLGWhiz

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

Word macro that can call cells out of Excel for a find and replace 0
changing location of words either in word or excel 1
Integrating information from Word to Excel (not mail merge) 1
Can't seem to delete all images from a Word Doc 2
Word doc keeps changing to ALL CAPS 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
On Enter: next row copying certain fields from previous row 18
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3

Top