ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can't create a spreadsheet from a word doc? (https://www.excelbanter.com/excel-programming/371967-cant-create-spreadsheet-word-doc.html)

[email protected]

Can't create a spreadsheet from a word doc?
 
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?


JLGWhiz

Can't create a spreadsheet from a word doc?
 
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.

" wrote:

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?




All times are GMT +1. The time now is 07:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com