How to Export Delimited Text File in Excel
In this article, I am going to show, how can we export Delimited Text Files in Excel. For Example, you have a file which is Comma delimited Text file or Pipe Delimited Text File etc. This file you want to export in to Excel in such a way that Delimiter is treated as a Column. It mean wherever it finds the delimiter, rest of the Text is put in next Cell (towards Column).
Follow the below Steps to Export a delimited files in Excel:
Example: For Example i have taken one Text File, which is Pipe Delimited as shown below:
Step 1. Select any Cell from where you want your File to be Exported.
Step 2. Go to Data Tab
Step 3. Click on “From Text” Option
Step 4. Now Browse your File and Click OK
Step 5. Choose option as “Delimited” as highlighted below and Click Next
Step 6. Here Select any one of the Delimiter Like Tab, Semicolon, Comma and Space. If your Delimiter is not one of these Values then Select Delimiter as “Other” and Type the Delimiter in the Highlighted Textbox.
Note: In the Above case i have Types Delimiter as “Pipe Sign” (|). You can give any character which is used as Delimiter in your Delimited File.
Step 7. Click Next
Step 7. Finish.
Step 8. Now Select the Cell Address From Where you want to Export your Data. By Default, it will have the same address which is selected in Step 1.
Now you can see that all the data is Exported in Excel.
- Restrict to fixed text or integer length in the given range of cells Follow below steps to Restrict to fixed text or integer...
- How to run a .bat file (Batch File) by Excel Macro By executing the below code, you can run any .bat...
- How to restrict some key or Characters in text box in a Excel Macro When you are using Text Boxes in Excel Macros then...
- File Name Formula There are few instances when we want to store the...
My name is Vishwamitra Mishra. Friends Call me Vishwa. This blog is authored by me. I am an Excel Geek. Well, this blog talks a lot about my passion in Excels & Macros so I’ll not talk about it :) I am very much passionate about traveling & quite recently discovered that I am a good photographer too..:P
AND GET A FREE!
E-BOOK FOR EXCEL VBA BEGINNERS
DON'T MISS ANY NEW ARTICLE !
Get your FREE! E-Book & Have Every New Article Delivered Straight To Your Email-Box