How to extract and classify data from a column in excel?
You need to perform a few preprocessing steps.


Convert your excel file into some sort of text file (csv is possibly the easiest)
Manipulate the file with python, either directly reading the file or with libraries such as the csv python module or pandas.


Last word of advice: Regular expressions are wonderful, but I think you might be using them for the wrong task, I strongly recommend you to take a programmatic approach.