Hello Every one,
I want to split one column into two columns, according to the lenght of the members. The members of each cell are seperated with ";".
For example:
Col. D
1;1234567;12,123;123456789;12345;1234
Now i would like to put those members of col. D in to colm F, whic are longer than 4. The members which are smaller should remain in Col. D
Col. D
1;12,123;1234
Col.F
1234567;123456789;12345
I have chosen numbers here only to simplify the problem. The real list contain of words and sentences seperated by ";"
I will be very thankfull for each assistance.
Bookmarks