It's because it's an array formula, instead of one cell like left(B1,6) you
use the whole range
and with the exception of sumproduct all these formulas need to be entered
that way,
you can lookup array in help

--

Regards,

Peo Sjoblom

"KIM" wrote in message
...
Sorry guys just tried both formulas again but finished by pressing ctrl +
shift & enter and it has worked. Sorry novice about - what does ctrl +
shift
& enter do?

Thank you