Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
How can I split this cell into key/value rows?
Apple (a1), 3(a2)
Orange (b1), 4(b2)
If I just call split(), I get:
SPLIT(A20, ","))), , 999^99)), "♦")), " ")))
Required, but never shown
3 months ago
2 months ago