Originally Posted by Spencer101

Hi Andy,
Have a look in the help function for details on "text to columns". This should make what you're trying to do a doddle.

Failing that, attach the lists and i'll help from there.

S.