Hello!
Thank you in advance for all the support, I'm wondering if you could help me with an approach to this:
10003|TRUE|[{*day*:*mon*,*amount*:3463.98},{*nig*:*tue*,*amount*:77.09}]
I have a column of data that looks like this, all of the above is in the same cell, I need to extract the numbers, i.e. 3463.98 in one cell and 77.09 in a different cell.
Does anyone have any idea of which formula I can use? I've tried with a combination left, mid, find, etc but I haven't found any success.
Bookmarks