import TXT to EXCEL

Hi,

We received a TXT file from our client.  It is a ; delimmited file.  But, based on their instructions, we should not be using delimited to import the file into Excel.  We should use Fixed width, they ask us to put lines before and after ;.  When the process is done, each ; has it own column, my question is, how can I remove those columns?  thx
mcrmgAsked:
Who is Participating?
 
TracyVBA DeveloperCommented:
Yes, follow these steps.

- Open your text file with excel
- Select column A and then click Data --> Text to columns
- Select Delimited and click Next
- Select Semicolon and click Next
- Then for each of your columns in the Data Preview section, select the column, then click Text.  Then select the next column and click Text again, etc. until the last column.
- Then click Finish
0
 
TracyVBA DeveloperCommented:
If there's a semicolon for each break, then you should use delimited, instead of fixed with.  Use delimited and choose semicolon as the delimiter.  When the data is split, the delimiters are not shown.
0
 
mcrmgAuthor Commented:
okay, is there a way to forace all columns are txt instead of general? and save the step?thx
0
 
mcrmgAuthor Commented:
cool...

is there a way to save the steps?  thanks
0
 
Patrick MatthewsCommented:
Do as broomee9 indicates above whilst using the macro recorder, and then post the code the recorder renders here for clean up.

No points, please :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.