Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel to Tab Delimited Question


  • Please log in to reply

#1
adams0423

adams0423

    Member

  • Member
  • PipPipPip
  • 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!
  • 0

Advertisements


#2
adams0423

adams0423

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 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?
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP