Find word or string from csv/text file colum A and post the value on next colum (same raw) Value in Excel

Mil

New Member
Joined
Jul 12, 2022
Messages
1
Office Version
  1. 2021
Hi all,
I need your kind help, I have an excel file with a list of equipment, in addition I have a number of text files containing answers of commands I typed and the output of the answers from the devices (output of PUTTY software that I saved as CSV). From the excel file (for each particular cell) I will search for a particular word in the CSV file (column A) and display the output that follows it (from column B).
Thanks in advance to the assistants!

Sorry for my broken english... need help the creat VB or macro or power query for that.... :)
 
Last edited by a moderator:

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

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