I’m looking for help extracting portions of CSV text within a long array, but the order within varies. For example…
Record 1 Array:
Record 2 Array:
Record 3 Array:
Could someone point me towards a FIND formula that will display just one of each of these in a unique field, please? And ideally the start info is trimmed off, too. Resulting data…
I’ve been going round the houses trying to find a solution, any help very much appreciated.