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