Hi,

I'm only a basic Excel user so have no idea if what I want to do is possible or not, so apologies if this is totally incoherent.

I'm cleaning up data in Excel, and I'm working on >2000 rows so editing manually is really time consuming. I basically need the content of Column E (text) in my spreadsheet to match the content of Column A. The content of E does usually contain the content of A, but with extra data that I need to get rid of.

eg, Column A will contain 'Three Steps To The Ocean' and Column E will contain 'Three Steps to The Ocean - EU.TOUR Feb 25 - Mar 06'. I need to get rid of anything that isn't 'Three Steps To The Ocean.'

Is there a way of using Find and Replace to search each row in Column E, and if the content of the same row in Column A is found, to replace it with ONLY the content of Column A, so the extra data is removed?

Please ask me to clarify anything I haven't been clear on! Any help at all would be immensely appreciated.