I am very new using macros so please be understanding. I have several spreadsheets that have same column with same information.

Original text: Production-Valecia, Production-Pasadena, Production-San Diego etc. (total of 21 different locations) I want to create a macro that will delete the word "production" and just leave the name of the city.

Thank you in advance for your help.