Can you give some example of the data within the column.You can find a separator with excel function find.special and use thiswith vba code and coninue searching from that point on to the nextseparator until it run into the length of the string