Splitting postcodes in Excel. 1

[postmanphat]

Hi,

I've got a list of postcodes in the format 'xxx xxx'. What I need to do is lose the last 2 digits in the postcode leaving me with 'xxx x'

e.g. I have the postcode 'PO2 4FR', but I only want the cell to contain 'PO2 4'

Any help would be greatly appreciated.

Dave

 

[SkipVought]

Hi,

Take a look at Data/Text to columns...

Skip,

_[red][/red]

 

[postmanphat]

Excellent! Give yourself a big pat on the back.