How can I extract the digital part, e.g. "23" in "s 23 secs." in all the column cells

Dear all,

There are some data in my column, like
"s 23 secs.
s 20 secs.
s 26 secs.
s 12 secs.
s 29 secs.
s 11 secs.
s 38 secs.
s 17 secs.
s 27 secs.
s 17 secs.
"

How can I extract the digital part only from this column, e.g. make "s 23 secs." as "23", whilst the rest are with the same principle.

Thanks in advance,

Regards,

DXMM2007

Hey oldchippy,

Thanks for your reply.

It works successfully for the single cell in the column. However, I wanna do it for each item in the column. Say there are 500 items need to convert in the column, how can I do it automatically?

Originally Posted by oldchippy

Try this,

=
MID(A1,3,2)*1 by multiplying by 1, you can then use the number in calculations

Originally Posted by oldchippy

Hi, just auto-fill down the column

Hey oldchippy,

Thank you so much for the pics and suggestions!

I realize how to do it!

Regards,

DXMM2007