Is there a better way to edit data in excel than what I'm currently doing?

If the data is in text format try using a program like CSVed to perform your cleaning operations. You may be able to automate it better.