What are the rules you want to apply. The original example implied you
wanted just the first of the three characters. If you're looking to
find the characters to the left of the space, e.g. return BS23 when
the full code is BS23 3EB then use the formula

=LEFT(A1,FIND(" ",A1)-1)

Rgds


On Sat, 16 Sep 2006 03:35:01 -0700, Aristobulus
wrote:

Thank you - can you show me how I should amend formulae for e.g. BS23

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________