Try this:

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Don" <Don@discussions.microsoft.com> wrote in message
news:1661F9CA-506C-445A-BF28-09485B0D233B@microsoft.com...
Hi,
I am preparing a Pivot table from a s/s with multiple columns ..One of the
columns is 'Post code'. In each post code cell is identified a unique post
code which is a two part code in the format AABB CAA (where AA=alphabet
characters, B=numeric 0-99, C= numeric 0-9. There is always a space between
B
and C.
Is there a formula I can define that will simply import the first part of
the code into a new column? So for example for RG7 4TY I will capture RG7 in
the new column, but equally it will accomodate scenarios where the first
component is 4 characters ... So for example with post code RG12 IBP, I will
simply capture RG12?

I am guessing there is a way to do this? Would appreciate assistance!

Don-