Using Pandas, how do I strip part of a cell from an Excel file?
String operations on particular columns (or series) can be done by appending .str to the series. You can use the following command to get your output:

&gt;&gt;&gt; df['Case Number'].str.strip('Case ID Number - 00')


You can refer to the documentation here Working with text.