Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
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?
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).
\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).