Not sure I've labelled this correctly. 

I have a bunch of cells containing strings of data. Each cell consists of something like this:

```
q1 = 1   | q2 = 3.2 | q3 = 5.6
q1 = 1.8 | q3 = 2.1 | q5 = 1.4

```

\*Note: The delimiter is litteral, all that text is in a single cell, with a pipe char.

I want to loop through each cell, explode (to use the PHP term) by the pipe (|) delimiter, and then do so again by the = sign.

I want to create an array for each possible value to the left of the equal sign, and add the value found to the right to the array (not add as in sum, add as in append to the array).

Visually, I think the array should look something like this:

```
Vars[
q1 [ 1,1.8 ],
q2 [ 3.2 ],
q3 [ 5.6,2.1]....] 

```

End goal being I'd like to get the average, mean and median for each of q1, q2 and q3.

Is this doable in VB? I'm more familiar with PHP, but would like to keep this in Excel.

Thanks.