Column A has 3,500 rows with lots of excess text,below is
some example text.
I need any row that says "MAC Address = " and the two rows
above it, copied onto sheet 2. Basically the only
information I need is, the MAC Address and Username all
other text is useless.
Thanks,
Melissa

Ex.
H:\nbtstat -a 10.22.23.22

Local Area Connection:
Node IpAddress: [10.22.2.193] Scope Id: []

NetBIOS Remote Machine Name Table

Name Type Status
---------------------------------------------
WDMECH001839
NADSUSEA
WDMECH001839
WDMECH001839
WDMECH001839$
NADSUSEA
JOANNE.EMELOP

MAC Address = 00-08-74-CB-A7-96


H:\nbtstat -a 10.22.23.23

Local Area Connection:
Node IpAddress: [10.22.2.193] Scope Id: []

NetBIOS Remote Machine Name Table

Name Type Status
---------------------------------------------
WDMECH001384
NADSUSEA
NADSUSEA
WDMECH001384
WDMECH001384
JOSEPH.RESSLER

MAC Address = 00-08-74-C9-9E-D0


H:\nbtstat -a 10.22.23.24