I have a column Title as shown in the attached excel OriginalColumn.
I need to split this column into 5 different columns with max of 35 characters each.
The rules are:
1)Maximum characters allowed in each of these split columns shouldn't exceed 35 characters.
2)The split columns as shown in sample data requiredsplitcolumn shouldn't be cut in middle of a word.
So, basically I need to split the words without cutting them in the middle ...but then for some bigger Titles if split columns exceeds more than 35 characters length it should be cut at a different point (e.g character 32) to reflect a complete word.
This applies to each of the five split columns.
Any ideas how to get my required Final resultset???