Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Excel to Tab Delimited Question

Started by adams0423 , May 05 2009 06:39 AM

Please log in to reply

#1
adams0423

Posted 05 May 2009 - 06:39 AM

Member

Member
123 posts

I have an Excel spreadsheet with columns A-G. When I do a Save As... Tab Delimited, it is successful, but it is saving many extra columns, so that each line ends with 15-25 extra tabs. Unless I go through and remove all the extra tabs, the file won't work in the program it is feeding.

Any suggestions on how to create the tab delimited document without extra columns represented?

Thanks!

#2
adams0423

Posted 05 May 2009 - 09:49 AM

Member

Topic Starter
Member
123 posts

I tried opening the file in Google Docs, and then saved as a text file and it worked beautifully. I'm sure there is a way to do it in Excel, though, so if you have ideas, please let me know.

The last column contains up to 800 characters of text. Perhaps Excel is adding columns to compensate for that extra text?