Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.