Hi,

I want to return everything up to and including, the first letter of the second half of UK postcodes. They take the form "BN2 6DE" or "DN28 7YT". As you can see the first section can be either three or four characters. What I am looking for is a formula that locates the space in the string and then returns the adjacent character and everything preceding and including the space.

The Postcodes are stored in {T_OrderHeader.ShipPostcode}.

I had tried removing the space and returning a set number of digits but this still leaves me with extra data as the first section can be either 3 or four characters.

Please can anyone help? You will be saving me a lot of time manually adjusting entries in Excel!