I have a column of words that is preceded by a number. I need to separate that number out into a separate cell so that I can easily compare it with another list that separates the number from the word. I have included an image below so that you can see what it is I am trying to do:
I am using Excel 2007. What is the easiest way to do this?