Hello,
Can somebody please help me in finding out the answer of the below problem :
I have a large text in one cell (2000 to 5000 characters). There are small sentences in this text each separated by a comma (,). I want to split this text in 1000 characters in each separate cell.
I can do that by using Left and Mid function which I did and it works fine but I don't want the sentences to break. These formulas will give me exact 1000 characters which could be anywhere within the sentence but I want the result to end before the comma or 1000th character, which ever is earlier.
The result should follow the below:
A - Characters not exceeding 1000 in any cell.
B - Sentence should not break and the result should end before the last comma or 1000th character, which ever is earlier.
C- The next cell should pick up where the previous cell ended but starting should not be with comma (').
If anyone having any idea of how to sort this I would be highly grateful. Thanks
Can somebody please help me in finding out the answer of the below problem :
I have a large text in one cell (2000 to 5000 characters). There are small sentences in this text each separated by a comma (,). I want to split this text in 1000 characters in each separate cell.
I can do that by using Left and Mid function which I did and it works fine but I don't want the sentences to break. These formulas will give me exact 1000 characters which could be anywhere within the sentence but I want the result to end before the comma or 1000th character, which ever is earlier.
The result should follow the below:
A - Characters not exceeding 1000 in any cell.
B - Sentence should not break and the result should end before the last comma or 1000th character, which ever is earlier.
C- The next cell should pick up where the previous cell ended but starting should not be with comma (').
If anyone having any idea of how to sort this I would be highly grateful. Thanks
