Google Sheets: Split data and delete first part of each new cell
<p>I'm feeding data from a SAAS into a Google Sheet, and would need to format it a bit to be able to work with it.</p>

<p>Most columns are ok, but one column has multiple parameters in one. Each cell looks like (data anonymized):</p>

<pre><code>affiliate_fees: None
affiliate_percent: 0.X
amount_refunded: 0
author_fees: 0
author_id: xxxx
author_percent: 0.5
coupon_id: xxxx
created_at: 2016-xxxxx
currency: USD
custom_gateway?: None
earnings_usd: None
meta: {u'url': None, u'class': u'transaction', u'image_url': None, u'description': None, u'name': u'xxxx'}
net_charge: xxx
net_charge_usd: xxx
paypal_payment_id: PAY-XXXXXXX
purchased_at: 2016-xxxx
refundable: True
sale_id: xxxx
status: None
stripe_charge_token: None
stripe_invoice_id: None
total_fedora_fee: None
total_processor_fee: None
user_id: xxxx
vat_fees: None
</code></pre>

<p>I've already found out how to <code>SPLIT</code> the data into different columns - I'm doing it via <code>=SPLIT(CC2,CHAR(10))</code></p>

<p>Now what I'd like to do, ideally in the same operation, is to remove the part before the first colon <code>:</code> </p>

<p>So the goal is: ending up with only the values (part after the <code>:</code>) spread into different columns. I can manually enter the column names. For examaple:</p>

<pre><code>--------------------------------------------------
| affiliate_fees       | affiliate_percent       |
--------------------------------------------------
| None                 | 0.X                     |
--------------------------------------------------
| ...                  | ...                     |
--------------------------------------------------
</code></pre>

<p>Any hints? Thanks for your time!</p>

<p><em>Note: I don't really need the <code>meta:</code> line, it can be discarded. I just left it in there because it might (or might not?) make things extra tricky</em></p>