Modification to existing VBA code

[Jed_c]

Hi all, I am new to the forum and an intermediate/average skilled user of excell. Some time ago I had help creating a VBA code to take the following expression, "WL1054070812", and turn it into Water Level 10:54 7th August 2012. I have attached the .txt document of this.

I am now wanting to change this so that instead of WL1054070812 becomming code, time and date, it would be code, RL (level) and date, where the RL would still be a 4 didgit number. The new 12 digit code would be TG1054070812.

The 12didgit code would be in Cell B, with the intention of cell B becomming becomming the RL ,and then Date in Cell F. The TG will just dissapear and only be used to recognise a value for the macro to run.

This should be simple I am thinking, ecpecially given the starting code I have.

If someone could help out though it would be much appreciated.

Cheers

Jed