extract content .txt file

  1. S

    Split Text into 1 Column from String

    Hi guys, I'm trying to extract the first and last name from the string below into a Cell. <tbody> https://websitename.com/tour#/first-last?p=237 </tbody> I tried the following function "=RIGHT(C2,LEN(C2)-SEARCH("bands/",C2,1)-5)", but only getting "first-last?p=237". Is there a way to get...
  2. C

    Importing multiple text (.txt) files to excel with VBA loop

    I am using excel 2003. I need to import multiple text (.txt) files into excel. Below is an example of the type of text file that I need to import. Importing in and of itself isn’t the tricky part, but I have 125 files to do every day. I know I can use VB to automate and loop through this. I...
  3. R

    Extract contents from multiple .txt files into a single worksheet

    Hi there, I have over 100 .txt files and need to extract the contents from each file into a single excel 2007 worksheet. I dont know if there is an easy way to do this other than manually opening each file and copying the contents? I would appreciate your help or any suggestions! I have...

Watch MrExcel Video

This Week's Hot Topics

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
Top