Kim

I was interested in this problem too so I tried your solution. It separates the strings into three columns, not two, because of the two sets of spaces. You can then get rid of the third column as Mikeburg wanted, but is there an easy way to get the first two columns back together again. The "merge cells" button doesn't seem to work, and using CONCATENATE introduces a circular expression problem.

Any ideas?

Regards

Robert