Exporting without Quotes
I am working a Google Base/Shopping feed for my company. For those who are not familiar with what this requires as small bit of info on it: I create an excel spreadsheet with all of the information about my products (descrip, price, colors, photos, etc etc etc).. One product per row. To upload the feed to Google I must export the file into a text (.txt) file-- tab-delimited.
I have a few issues:
1) "Plan white tee shirts 8""50"" --- it double quotes some stuff and adds quotes where I have not placed them while working the excel spreadsheet. How do I export without these extra quotes? This entry should read Plan white tee shirts 8" x 50" ... Maybe I need to get rid of the " (or inches) all together?
2) There is a column for 'additional image links' -- when you add an image to one of these products you just provide a link- well if I have multiple I can product multiple image links. Help section in my Google merchant account informs me to separate multiple links with a comma. I do- yet after saving and opening the document again cells with more than one link in it is shown as #######
I have tried expanding the cell- no luck, it is exported like this into the text file, I have checked that there is a 'space' between the comma and the next link... Not sure what to do here.
Note: I have another computer with Office 2010 on it- think these are just 2007 issues? Any help is greatly appreciated!
|