Hi,

I have a workbook with text in the cells in column ‘A’ i.e. A2 to A1500, which is not in a standard format i.e. the text can be of any size.

What I would like is the macro code to look at each cell in column ‘A’ and extract 3 strings of text (if they exists) and copy them into the corresponding cells in column ‘B’, ‘C’ and ‘D’.

Now the hard part…the three sets of text required (to be found and copied into the corresponding cells in column ‘B’, ‘C’ and ‘D’) are in the format of :-

KU2\\ABxxxxx (User)

KU2\ZABxxxxx (User)

KU2\DGxxxxx (User)

N.B. where xxxxx can be any number e.g. 00125, 01235, 12345, 89521 etc etc

Any assistance would be greatly appreciated



Many thanks in advance



Rob