I have some postcodes which I would like to just get the first part of the postcode so for example
BD20 8BD would get returned as BD20
LS2 4JK would get returned as LS2
So basically I want the first part before the space. What function can do this in Excel? as I cannot seem to find one that works Or if this can be done in Access?