New line within the same cell

Hello

I have been trying to look at other posts for this topic, but was unable to find a solution.

I have text in one Excel cell:

01/01/22: knioaivneioiekiadfnkdhi iofnenwoij oiehfeinfeio idioem
2/1/22: cimkcibm eknkgoeg fkeing
3/1/22: ckkmvkeg eifknke

I want it to stay in that format. Now, Alteryx just takes all the text in one string and doesn't divide it up.

I've attached sample Excel file.

Many thanks for any suggestions!

Workflow

Accepted answers

Just reading in will give you the data in single cell.

Workflow:

Hope this helps : )

Here is how you can do it.

Make sure to set the input tool as First row contains data.

Then split to new lines in regex

Hope this helps : )

Hi!

Sorry, I was unclear, I need the lines to stay within the same cell and not split into three cells. How can i do this?

Many thanks!

Happy to help : ) @Savannah

Cheers and have a nice day!

Perfect! Many thanks! 🙂

Happy to help : ) @Savannah

Cheers and have a nice day!