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-