Split text to cell using formular

Hi


I'm looking for a formular to split different text bits from one cell into different cells.


Here's what I have in the cell - there are 2 line breaks between each line in the cell:


"

Name: Yo Mama


Address: Yamaha Street 31


City: Yoyo Town


Country: Japan

"


How do I get each variable into my columns for Name, Address, City and country?


I've tried looking into LEFT, MID, RIGHT and using CHAR(10) as a delimiter, but I can't really get it to work for me.


Hope someone can help, all the best!

OS X Mavericks (10.9.1), Numbers 3.1

Posted on Sep 17, 2018 3:10 PM

Reply
3 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Split text to cell using formular

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.