Hi,
I needed help with something I am working on in excel. I have a column of text. The length of the text is greater than 30 for eg 45. The length varies upto 60 characters in length. What I need to do is to break it up into two where each new text length should be less than 30 chars. The difficult part comes in when I split the text into two I need to spilt it such that a word is not split halfway for eg.
Orginal Text : “This is a line of text which is greater than 30 charcters”
New Text 1 : “This is a line of text which “
New Text 2: “is greater than 30 charcters”
It should not spilt any word ie it cant be : “This is a line of text whi” it needs “which” to be a whole word, if by chance length is 30 chacrters in the middle of the word the whole word is carried over to the next line of text.
Can someone pls help on how to get this done in a smart way cause I need a list of couple of thousands of rows to do this for and I cant be manually cutting and pasting it. Thank you in advance.
I needed help with something I am working on in excel. I have a column of text. The length of the text is greater than 30 for eg 45. The length varies upto 60 characters in length. What I need to do is to break it up into two where each new text length should be less than 30 chars. The difficult part comes in when I split the text into two I need to spilt it such that a word is not split halfway for eg.
Orginal Text : “This is a line of text which is greater than 30 charcters”
New Text 1 : “This is a line of text which “
New Text 2: “is greater than 30 charcters”
It should not spilt any word ie it cant be : “This is a line of text whi” it needs “which” to be a whole word, if by chance length is 30 chacrters in the middle of the word the whole word is carried over to the next line of text.
Can someone pls help on how to get this done in a smart way cause I need a list of couple of thousands of rows to do this for and I cant be manually cutting and pasting it. Thank you in advance.