copy/import text file

[Trevor3007]

Ethernet

(Intel(R) Ethernet Connection I219-LM, 12:q1:Dc:E2:bf:47, 321.765.689.972) is connected to:

------------------------------------------------------

Switch Name: 4b:r1:87:2c:89:65

Switch Port: Ab6/0/55

Switch Name: Grpodb01zrq004.bu.fr.com

Switch Model: Cisco IOS Software [Gibraltar], Catalyst L3 Switch Software (CAT9K_IOSXE), Version 16.12.3a, RELEASE SOFTWARE (fc1)\0x0aTechnical Support: http://www.cisco.com/techsupport\0x0aCopyright (c) 1986-2020 by Cisco Systems, Inc.\0x0aCompiled Tue 28-Apr-20 09:37 by xserg

Switch Port: USER / VOICE

Switch IP: 354.7.269.951

VLAN ID: 08



Good day,

I have several txt files like the above that I have to ‘copy/import’ into excel.


However, I only want the hollowing to be included in the headings shown below:-

Ethernet

Switch Name

Switch Port

Switch Name

Switch IP:

VLAN ID

And as there are many files to copy into, can the next file have a blank ‘row ‘ after the previous and paste in(colured if poss too) ?


Please attached


Thank you inadvance & hope that soemone has the 'know;ledge' to do this..
Trevor3007