Hi all,
Damn these postcodes
I would be very appreciative if someone could help me out. I've attached a worksheet, it's sample data with a few records, but what I'm trying to do is move all of the postcodes into one column. I can use a filter on the attached example on column I, but in a real world scenario there are too many extra place names to make this a viable option.
Does anyone know if there is an IF function that can help me separate all of the postcodes into one column, and then a way to be able to delete the postcodes from the original cells after they have been arranged into one column?
I'd really appreciate some help with this. I'm a complete noob, and this is making up a big part of my new job
Thanks.
Bookmarks