Edit for special filter and count...

Originally Posted by superspurs

...

However, I want to do this just on postal area, so I need to edit the info so the last 3 characters of the post code are removed, eg...

SE10 4BX

becomes

SE10

other than doing it manually is there anyway to just command excel to delete last 3 characters from my list?

Try using this formula in an adjacent column to get rid of last 3 chars

=TRIM(LEFT(A2,LEN(A2)-3)) where A2 is first postal code to strip.

copy it down

Then copy the whole column and do an Edit|Paste Special >> Values over the old data... then delete the newly added column.