thanks ok

how abou a fieild with only 2,3 words havin the first column everything
besides last word in 1 column last word in second column?


"dk" wrote:

We would like to split a field which has sometimes 3,4,5, word in the field
the split should be as follows left word shall be copied in 1 cell, right
word in 1 cell ,all middle words together in 1 cell