Hi, I am creating a chart to show survey results. Each question on the survey is varying in in length from 50-200 characters. When I create the chart many of the questions are too long to display. So I have created a method to split the lines dynamically. Below is my code followed by the problem I'm facing:
=if(len(QuestionTXT) < 50, //if the length is more than 50...
& chr(13) &
right(QuestionTXT, round(len(QuestionTXT)/2)), //then split it into two lines