How to split text in a column with wrapped text in several lines in 1 cell

Question

I have 1 cell with 3 or more seperate lines (wrap text). Is it possible to split this into 3 seperate cells with 1 line? The column comes from a download from Workday.

Answer 1

Hi,

You can use the TEXTSPLIT function to get the result.

For Column try this formula:

=TEXTSPLIT(A1,,CHAR(10),TRUE)

For Row try this formula:

=TEXTSPLIT(A1,CHAR(10),,TRUE)

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.