Hi,
We are really getting closer but for bigger data's we can't break the word.
In this function, can we add one morefunction of breaking the sentence where there is a space within 32 characters but not to take all spaces into account. for ex;
1567 TOPS RESTAURANT VISTA CORNER TP CROSSING...
Hi chippy
If I go for delimiter by using a space that will create so many columns. If the original column filled with 60 characters, I want to split the text into two columns max of 32 characters for example in orginal text it is like this.
column A (ROW1): 52/1234 PADMAVATI FLATS BEHIND...
Hi
Could you please help me how to split large text into different columns without breaking word and also the column width should not be more than 32 characters
for ex:
column A (ROW1): 52/1234 PADMAVATI FLATS BEHIND NEW FARIDA MARKET POONAM MARKET
column A (ROW2): 1567 TOPS RESTAURANT...