And if you do... I have an addresses spreadsheet where the addresses are all different lengths, so the postcodes are spread out over 3 different columns. I know it should be possible to move them all to one column but how? I can't merge because only one of the three columns is exclusively postcodes at the moment and I want the non-postcode stuff to stay where it is.
I've got as far as filtering the postcodes using \d\w\w but how do I move them?
Actually I probably wouldn't even do that - just sort on the last column, copy the postcodes over to the postcode column and delete them. Now sort the rows that haven't yet been fixed on the last-1 column, copy over and delete. Repeat.