Taadaa
It works exactly right
Many thanks
Stephen


"Steve Dunn" wrote in message
...
Stephen,

just replace the last "" with A1.

Max,

that's pretty neat! I particularly like the INDEX(array,) wrapping to
elimate the need for array entry. Definitely something I'll be putting to
good use. Cheers.

Steve D.



"Father John" wrote in message
...
Hi Max
Thanks for the effort here!
Not sure now of the entire structure of the expression as the correction
doesn't show if I am replacing a section or adding to it would you be
able
to retype the entire line?
With thanks
Stephen West
Gold Coast, Australia

"Max" wrote in message
...
A slight correction to the end part of the expression. It should read:
... )),),0)),"")),A1)