Import specific values of text file to Excel sheet

T

Tushax

New Member
Joined
Dec 16, 2021
Messages
1
Office Version
  1. 2007
Platform
  1. Windows
Dear All, I want to import specific values from text file to excel sheet row.
Image of text file is attached with name as OUTPUT.
The values marked with red color required to be imported to corresponding name in excel sheet in a single row.
How can i get it VBA code?
 

Attachments

  • Excel image.JPG
    Excel image.JPG
    77.4 KB · Views: 18
  • Output.JPG
    Output.JPG
    93 KB · Views: 18

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
You must log in or register to reply here.

Similar threads

W
  • Question
How to add "edit text import" to get data from an external text file?
Replies
3
Views
148
waljbt
W
E
  • Question
Importing Project
Replies
2
Views
173
Fluff
Fluff
R
  • Question
EXCEL VBA Import CSV large numbers as text
Replies
2
Views
168
jkpieterse
jkpieterse
M
  • Solved
Copy the last sheet from file to another with ignore empty whole column
Replies
7
Views
169
mumps
mumps
J
  • Question
Automatically import .txt files into separate sheets in Excel
Replies
1
Views
185
John_w
J

Forum statistics

Threads
1,214,981
Messages
6,122,566
Members
449,089
Latest member
Motoracer88

Share this page

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