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.
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.