Closed Thread
Results 1 to 11 of 11

How to import bulk text files to excel cells

  1. #1
    Registered User
    Join Date
    09-09-2014
    Location
    masr
    MS-Off Ver
    2007
    Posts
    23

    How to import bulk text files to excel cells

    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

  2. #2
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: How to import bulk text files to excel cells

    try this solution.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: How to import bulk text files to excel cells

    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

  4. #4
    Registered User
    Join Date
    09-09-2014
    Location
    masr
    MS-Off Ver
    2007
    Posts
    23

    Re: How to import bulk text files to excel cells

    I'm sory - I recent find the solution elswhere
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-09-2014
    Location
    masr
    MS-Off Ver
    2007
    Posts
    23

    Re: How to import bulk text files to excel cells

    sorry for bad reply
    Last edited by drhema; 02-01-2015 at 01:52 AM.

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to import bulk text files to excel cells

    Quote Originally Posted by drhema View Post
    @xlbiznes Why you share malicious file?
    Where moderators here?
    Are You shiae?
    Please explain why you think the file is malicious.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  7. #7
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: How to import bulk text files to excel cells

    Quote Originally Posted by drhema View Post
    Are You shiae?
    This appears to be a religion-based insult. This is a warning not to repeat this behavior.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  8. #8
    Registered User
    Join Date
    02-28-2015
    Location
    UK
    MS-Off Ver
    2009
    Posts
    2

    Re: How to import bulk text files to excel cells

    Quote Originally Posted by drhema View Post
    I'm sory - I recent find the solution elswhere
    Please Login or Register  to view this content.
    Where do I use this code? I'm a complete noob to excel but it looks like the only thing that will do what I've been searching for on Google for several hours!

    Any help would be majorly appreciated!

    Anyone?

  9. #9
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: How to import bulk text files to excel cells

    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.

  10. #10
    Registered User
    Join Date
    05-03-2022
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    21

    Re: How to import bulk text files to excel cells

    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.

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,358

    Re: How to import bulk text files to excel cells

    2. The most recent post accuses a reader of hijacking the thread, for simply asking how to use a suggested solution.
    That's because the person in question DID hijack the thread in terms of our rules.

    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.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Bulk rename excel files based on values of two different cells
    By Czarny in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 01-20-2015, 10:47 AM
  2. Best Way to Bulk Import a Few Hundred CSV Files
    By Videoman22 in forum Access Tables & Databases
    Replies: 0
    Last Post: 07-06-2013, 04:29 PM
  3. problem with: import text files to excel -- format text
    By karthik123qwe in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-25-2012, 03:53 AM
  4. Problem in Bulk import of Excel data into SQL
    By sridevi kumaravel in forum Excel General
    Replies: 0
    Last Post: 10-25-2012, 07:58 AM
  5. Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2012, 01:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1