Extract strings from a longer text string

My subject is also known as 'I'm a complete noob at VBS within excel and need lots and lots of help'.

Long story short, I am a server admin of an online multiplayer game. Due to heightened popularity of said game, and the ease at which the base game can have scripts inserted in it, there are alot of people who try and ruin others fun by doing all sorts of wonderful things. In order to make life easier for the players on the server, I routinly monitor the logs and manually comb through them looking for all sorts of misbehaviours. I've come to the realisation that this manual labour sucks and that there should be a way, with excel, to speed the process up. I'll probably ask questions in steps to slowly build up this tool, and to also slowly learn by reverse engineering how to do VBS myself (eventually). I tried reading through some online guides, but most of it did not seem relevant.. and I don't really have that much spare time.

First thing I need is a macro that will comb through a workbook (1 column of data, variable number of rows), and extract certain information from within the text of the cell.

The macro needs to look for all instances of the text connected (id= then return the two bits of data within the text into a clean worksheet.

For example

9:47:44 Player excelgod connected (id=123987).

Time stamp is variable (can be 7 or 8 characters in length), player name is variable and ID is variable.

(PS, please let me know if this is the wrong subforum to be asking this)