Hi,

thanks for the quick reply,

I have just tried the above when I do this the first time recording the VBA it works fine and just splits into two columns, however when I try this again with the VBA I have recorded it splits the cell into 3 columns overwriting some other data in the 3rd cell?