如何将制表符分隔的文本文件导入Excel？ [英] How to import Tab delimited Text files into Excel?

问题描述

我有多个文本文件（.txt），Tab在文件夹中分隔。文本文件包含第一行作为列标题。我有一个预定义的具有列名称的excel模板。我可以将文本文件导入Excel模板。但是，我需要做的是如何分栏列标题不符合Excel列标题通过VBA。
提前感谢任何帮助.....

I have multiple text files (.txt) with Tab delimited in a folder. The text file contains first line as column headings. I have one pre defined excel template with column names. I am able to import the text files into excel template. But, what i need to do is how to delimit if the column heading not match with Excel column headings Through VBA. Thanks in advance for any help .....

推荐答案

可以在Excel本身， Office 2010中的数据选项卡>文本列。在那里，您可以选择它由分页符分隔，您可以在其中选择您的数据。

It's possible to do it in Excel itself, in Office 2010 its in the Data tab > Text to columns. There you can select that its delimited by tabs, and there you go, your data should be columnised

这篇关于如何将制表符分隔的文本文件导入Excel？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！