Hi
I have a cell in Excel which contains the following string

Avg:91.14,Std:0.96,Min:89.5,Max:94.2

How do I pick out just the Avg value (i.e. 91.14) and place that in
another cell?
I would like to do this for multiple cells.
The problem I'm running into is that sometime the Avg value 99.99
(i.e 6 characters as opposed to 5). This means I can't use the
=mid(text,start,characters)
forumla as the characters might be 5 if less than 100 and 6 if 100 or
greater.

Is there a way I could get Excel to recognise the ":" and "," and give
me everything in between?

ps. in another cell I'd also like to pull out the Std value.

Thanks in advance