I got a cell with the text:
THIS IS AN EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE GO TO NEXT ROW
How would I get excel to split the sentence above into 2 different cells A1 & A2, after the sentence exceeds 66 characters
So that-
A1: THIS IS AN EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE
A2: GO TO NEXT ROW
--------------------------------------------
Additionally, if the cell is 67 characters: THIS IS AN EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLEE
How would I split to to 2 different cells so the words dont get cut off half way?
A1: THIS IS AN EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE
A2: EXAMPLEE
THIS IS AN EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE GO TO NEXT ROW
How would I get excel to split the sentence above into 2 different cells A1 & A2, after the sentence exceeds 66 characters
So that-
A1: THIS IS AN EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE
A2: GO TO NEXT ROW
--------------------------------------------
Additionally, if the cell is 67 characters: THIS IS AN EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLEE
How would I split to to 2 different cells so the words dont get cut off half way?
A1: THIS IS AN EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE
A2: EXAMPLEE