Exporting without Quotes

[Chris1]

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!

[Chris1]

Anybody? Am I in the complete wrong place for an answer like this? Only curious and TIA for any help guys!!

[eNGiNe]

Erm ... this sounds like spreadsheet and .csv questions, and you're in the Word forum.

From an information point of view, you could save yourself a lot of grief by simply telling visitors 'all linear measurements are in inches'

I vaguely remember that ### often means "the data is too wide to be displayed in this column", typically after a spreadsheet has helpfully decided to convert something like 3/4" into March 2004 or similar.

But you'll get better answers in the Excel forum <g>

[Chris1]

Hey... Good point- my apologies.

[Capungo]

Chris,

Please check the link below:

http://www.cpearson.com/excel/ImpText.aspx

[Chris1]

I appreciate your response! Only as to help anybody else that runs across this issue (although your response would have done the same): I found a macro that would do this that may prove a bit simpler- MAY.. not 100% sure.
I actually did it all in visual basic (http://office.microsoft.com/en-us/ex...010014111.aspx) as adding a macro limited the amount of lines I could add for some reason:

Sub Export()
Dim r As Range, c As Range
Dim sTemp As String

Open "c:\YourFileName.txt" For Output As #1
For Each r In Selection.Rows
sTemp = ""
For Each c In r.Cells
sTemp = sTemp & c.Text & Chr(9)
Next c

'Get rid of trailing tabs
While Right(sTemp, 1) = Chr(9)
sTemp = Left(sTemp, Len(sTemp) - 1)
Wend
Print #1, sTemp
Next r
Close #1
End Sub

Copy/Paste- press F5 and it will export
Again- I appreciate everybody who helped figure this out!

[Capungo]

You are welcome. And your code works perfectly.