I learnt something today, that when using the mid function on a worksheet you must specify the third parameter, I have only used it in VBA till now where omission of the third parameter causes mid to extract the rest of the field from the start point.
Just thought that I would mention this as I...