Hi,
I have 1K text files in a folder
I want to import all text files into excel sheet in order to be every whole text file content in only one cell.
How can i do that?
Thanks
Hi,
I have 1K text files in a folder
I want to import all text files into excel sheet in order to be every whole text file content in only one cell.
How can i do that?
Thanks
try this solution.
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
I am a bit confused by your explanation. Do you wish to import all files into one master sheet where all the values in cell A1 of all the sheets are summarized in cell A1 of the master sheet? and likewise for all other cells? Or are you looking for something different? Please clarify with an explicit example.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I'm sory - I recent find the solution elswhere
Please Login or Register to view this content.
sorry for bad reply
Last edited by drhema; 02-01-2015 at 01:52 AM.
RomesFall
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
This is an odd thread.
1. I can't figure out how the proffered xlbiznes.xlsm spreadsheet would be relevant.
2. The most recent post accuses a reader of hijacking the thread, for simply asking how to use a suggested solution.
3. Therefore I'm not asking how to use the proffered spreadsheet.
That's because the person in question DID hijack the thread in terms of our rules.2. The most recent post accuses a reader of hijacking the thread, for simply asking how to use a suggested solution.
If they (or you, or anyone else other than the OP) want help with this, then they (or you) should start a new thread with a suitable title and, if necessary, link back to this thread or at least mention it in their (your) own thread on the issue.
I hope this clarifies the situation.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks