Thanks thatprobably works but it looks a little involved for me, However I t hink I found a way to do this using the text to columns feature so I will close this thread. Thanks again