Converting txt files to CSV files and Related Problem

ANONYMOUS123456

Board Regular
Joined
Jul 3, 2016
Messages
85
Hello Everyone,
I am converting 500 text files to CSV files by just changing the extension from .txt to .csv. The problem is, the the data in the text file is splitted into multiple columns of the first row of csv file. My objective is, when I convert the text file, then all of the data of text file should stay on A1 cell of the resulted CSV file. Can I achieve this objective ?
 
I don't what this says about me, but I've been using this site for years, and I have yet to post a image. Please tell me how. Do I have to have my own website url to post an image?

No, you don't have to own your own website. Just visit "http://tinypic.com/" . Upload your image over there, then in the next step they will give you the URL of the image, which you can post in this forum.

If you have still problem, then let me know. I will explain again.
 
Upvote 0

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Ok, I guess my company IT dept. doesn't want me to go to Tinypic. I'll look into other sites that offer the same.
 
Upvote 0
This is from my Google Drive Test

open
 
Upvote 0

Forum statistics

Threads
1,223,275
Messages
6,171,127
Members
452,381
Latest member
Nova88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top