Separate Wrap text to multiple rows in excel

Question

i've an issue which is i couldnt seperate wrap text cell to multiple row in excel,

here is the example :-

Wrap Text :

Without Wrap Text :

so now I want to separate the without wrap text to multiple rows, the details will be looks like in wrap text.

Answer 1

Try using TEXTSPLIT( )

---

• Formula used in cell B2

=TEXTSPLIT(A1,,CHAR(10))

---

Where CHAR( ) function returns a character specified by the code number from the character set for your computer, therefore in the above formula it splits by line break. CHAR(10)

---