Postal Codes

Hi All,

I have a list of UK postal codes that need shortening.  For example, some listings could be as follows;

SE1 XXX

SE19 XXX

WC1X XXX

I need a formula that will only take everything before the space (i.e. SE1, SE19, WC1X)  Can you please assist?

Cheers,

Baron77

 Try =LEFT(A1,SEARCH(" ",A1)-1) where A1 is the cell with the postcode.

Regards

Paul

 Many thanks indeed!

You could just do Data>Text To Columns with a delimietr of space, you get both parts in separate columns then.

 And...your next question will be to get just the Postal 'Area'... PO, SO, G, M, B, etc (Data in A1)

=IF(ISNUMBER(VALUE(MID(A1,2,1))),LEFT(A1,1),LEFT(A1,2))

Excellent stuff Nick - much appreciated.

Regards,

Baron77