Python Forum

My excel file name is Test.xls
Column A has 1000 rows. Each row has both char and int.
Eg. Tool cost for part no. 1236576
Mould for 5475943 for WER

I want a python code that will read column A, separate Integers from the sentence and paste the output in Column B.

Eg.
Column A ----------------- Column B
Tool cost for part no. 1236576 ----------------- 1236576
Mould for 5475943 for WER ----------------- 5475943

Can anyone help me with coding.

Take a look at the python docs: CSV File Reading and Writing