split string after 35 character limit

[Jairacha]

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.

Column1	Column2
Hello 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 solution]

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)

[Qiu]

@Jairacha 
Maybe we can use also RegEx