Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When I drag txt-files with strings and \t characters into my excel-sheet, excel can't handle the \t. Instead I have to type the tab-button in the txt-file. Why \t doesn't work?

share|improve this question

migrated from stackoverflow.com Apr 7 '13 at 3:56

This question came from our site for professional and enthusiast programmers.

    
Off-topic? Can you please explain why? –  kame Apr 5 '13 at 12:46
    
Off topic as this relates at most to (super) user the way the quesiton is phrased now. The question has nothing to do with programming as it stands. –  K_B Apr 5 '13 at 13:06
2  
Excel wont understand what \t means, you'll have to either manually replace them all with real tabs (or another delimiter) or create a macro to do a custom text-to-columns. The standard text-to-columns will not accept a 2 character delimiter (through the gui at least). –  NickSlash Apr 5 '13 at 13:11

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.