Excel help

[slinky malinky]

I have a spreadsheet with addresses and postcodes and other details. This issue i have is that some of the postcodes are in the wrong columns, as are some of the other address fields. Is there an easy way of searching for say the postcode format and moving it to a specific collumn.

 

[slinky malinky]

Sorry, i probably did not explain myself very well

I want all the postcodes in column J

 

[slinky malinky]

Probably be best to do the above via use of a macro and just have it go through the entire spreadsheet.

It is the case that everytime the cell in column J is empty the postcode is in the cell in column I?

most of the time yes, but there are other errors but i could correct those manually. when you say use a macro, do you mean record one or write one?

 

[slinky malinky]

ok, thanks for all the advice. a bit more information. the data, about 29,000 address records, was exported from a database to be input into another database. in the original database there is no postcode field specifically so when the address details have been input it has not been done the same each time, hence the postcode appears in different columns.

let me have a play around with that macro and see if i can get it looking better.