Save Excel as tab delimited

Richard Korts
Richard Korts used Ask the Experts™
on
See attached Excel spreadsheet.

I am trying to save this as a tab delimited file, When I do so, column M gets replaced with column L, and thus duplicated.

See .txt file as the tab delimited version.

I am using Excel version 14.0, part of limited Office 2010.

Thanks
Geotextiles--3.28.12.xlsx
Geotextiles.txt
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010
Commented:
Hello,

Your spreadsheet has a few hidden columns. i.e. D, E and K. The CSV file is correct. It reflects ALL your columns, including the hidden ones.

Unhide all columns in Excel, remove the duplicate column (either K or L) and then export again.

cheers, teylyn
Richard KortsBusiness Owner / Chief Developer

Author

Commented:
I knew about D & E. I didn't see K.

Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial