I have taken this data from our old site and removed most of the html code.
I have copied the data into a spreadsheet and this is what I have in my cells.
I have uploaded a small example of what I have. What I need the macro to do is remove everything in each cell to the left of the ">" character so just leaving me with a list of the placenames. I hope this makes sense.