split string after 35 character limit

Question

Hi I am trying to split a string from column1 into columns 1 and 2 once the string in column1 reaches the 35 character limit. Also, It doesn't matter if the string cuts off in the middle of a word.

Column1Column2Hello world! Insert test string here. Hello world!!!!!!!! Insert test string here. test1 test1 test2 test2 test3 test4

can someone help on how to do this?

Thanks!!

jrgo · Accepted Answer

HI @Jairacha

I'm thinking the SUBSTRING() function should work. it's a 0-based count so the first character would start at position 0, not 1)