Hi,
I have a list of text data (over 2000 rows) which I need to separate based on the month. This is an example;
Masldkfj: Simbisai 28 Jun 12 MAU/MSSU/MBS
Mrtyu: Regis 23 Jun 12 MAU/MSSU/MBS
Mrtuu: Regis 26 Jun 12 Beech 1
Sisdf: Jasbinder 29 May 12 Avon 3
Ssfd: Jasbinder 29 May 12 Avon 4
Ssdf: Jasbinder 31 May 12 Avon (1)ORTHOPA
Ssdf: Jasbinder 31 May 12 Avon (1)ORTHOPA
Each cell is of variable length and the month is in a variable position within the cell.
Can anyone advise the quickest way to do this?
Thanks in advance!
Bookmarks