Extract a list of codes from data

I've got data such as the following:

Resources Nl Materials0.0000ACSC:\Stocks\All Acrux Limited Pharmaceuticals0.0000ACRC:\Stocks\All Adamus Resources Limited Materials-2.5317ADUC:\Stocks\All Adelaide Brighton Limited Materials2.4242ABCC:\Stocks\All Aditya Birla Minerals Limited Materials1.1236ABYC:\Stocks\All Advanced Braking Technolo Automobile & Co3.5714ABVC:\Stocks\All Advanced....

and I want to extract a list of the three-letter alphabetic codes which appear directly to the left of every 'C:\' symbol - anyone know a formula or VBA code which could do this please? Thanks in advance.

Assuming the string in cell A1...

1st code: =MID(A1, FIND("C:\", A1)-3, 3)
2nd code: =MID(A1, FIND("||", SUBSTITUTE(A1,"C:\","||",2))-3,3)
3rd code: =MID(A1, FIND("||", SUBSTITUTE(A1,"C:\","||",3))-3,3)

If on the off chance you wanted a single delimited list then you could use a User Defined Function, eg:

Please Login or Register  to view this content.

the above, stored in a standard module, would be called from a cell along the lines of:

Please Login or Register  to view this content.

where A1 holds the string - the range you pass can encompass multiple cells (though it is assumed any multi cell range would be contiguous)