| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy only certain text
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy text between two different delimeters | New Users to Excel | |||
| copy text from 1 workbook to another by macro | Excel Worksheet Functions | |||
| Macro to delete a text box and copy in new one | Excel Discussion (Misc queries) | |||
| Macro to copy text from ColumnA to B | Excel Programming | |||
| Macro to copy daily text file | Excel Programming | |||
![Melissa[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
