Quote:Yes, I figured that out AFTER I did it the hard way. With step 3 of the wizard by doing Shift + Last col and ticking the text button . Anyway, now I have the spreadsheet to send to Harmony. BatPig's link to the codes wass very helpful. It was Logitec that threw in the wrinkle of wanting the codes submitted in Excel.
The way I brought the data in was to copy the data from BP into a Word file then using word find/replace I inserted a comma in all blank spaces. Then I removed the comma's from the titles and saved the file. Then I used wordpad to open the saved file and then saved it as a raw text file. I then used Excel>data>text file>import and the excel wizard recognized the file as a comma delimited file and when I selected comma it put all of the data into the correct boxes then on next I selected text>shift>last col and all data was recognized as text and imported correctly. I have not done anything with excel for years so I had forgotten most functions,
Seems like a lot of trouble to get My Denon AVR to work easy again. Now back to Logitec to get a new Harmony one or 900
Thanks everyone for your hellp.
Edited by generallee - 11/15/12 at 2:37pm