sids911

Easily! First, import the said txt file into excel. Now on another worksheet, use a simple formula like shown here to copy the data over. Don't worry, you only have to type the first cell, then you just drag the cell's corner handle thingy to fill in adjacent cells with it. Much thanks! I actually solved using a VBA macro script provided by a gentleman on another forum (since I had many files to convert). Not sure what the forum policies are, or else I would have linked to that thread. please let me know if I should if it could help someone else.

Hello Everyone, Its my first post here :-) I have a text file with values printed like these; BSSID: 001E4ABXXXX Last seen: 14/12/2011 - 16:06:12 Vendor: Cisco Systems Signal: -91 dBm SSID: NXXXX Enc: OPEN Mode: Infrastructure Channel: 1 (2412000 Hz) Rates (Mbps): 11, 12, 18, 24, 36, 48, 54, Packets: 25 Unique WEP IVs: 0 BSSID: C03F0E3XXXXX Last seen: 14/12/2011 - 15:57:27 Vendor: NETGEAR Signal: -96 dBm SSID: Misuss Enc: WEP Mode: Infrastructure Channel: 1 (2412000 Hz) Rates (Mbps): 6, 9, 12, 48, 18, 24, 36, 54, Packets: 7 Unique WEP IVs: 0 BSSID: 001E4ABXXXXX Last seen: 14/12/2011 - 15:56:49 Vendor: Cisco Systems Signal: -95 dBm SSID: Mobile Enc: WPA2-CCMP-MGT Mode: Infrastructure Channel: 1 (2412000 Hz) Rates (Mbps): 11, 12, 18, 24, 36, 48, 54, Packets: 2 Unique WEP IVs: 0 I want to export this all to an excel spreadsheet with columns representing BSSID, Last Seen, vendor, Signal, SSID, Enc, Mode etc., and all the values belonging for an BSSID in a single row. Does it look doable? If yes, please let me know how to achieve this, and I will be highly obliged. Much thanks! Sid