I have text string that is produced from code that can vary from approx 250 words to 1000 words.
In my sheet i have two merged cell areas. I need to detect if the text string is to big to show in the first merged area, if it is then it needs to split and the last viewable word and move the remainder of the text string to the second merged area.
Any help would be much appreciated
In my sheet i have two merged cell areas. I need to detect if the text string is to big to show in the first merged area, if it is then it needs to split and the last viewable word and move the remainder of the text string to the second merged area.
Any help would be much appreciated