write only numbers

[sandeephg]

hi guys and thank you in advance for your help.

What I am trying to do is search a numbers, which write only numbers

A B C D
ITEAMS QTY
PIN12345 45 12345
PRODU5689 66 5689
CUPS89744 555 89744
BOTTLE45656 TO 45689 895 45656 45689


So, I would want the formula result to display the only numbers in column C and D. Would anyone know how to do that? Thank you very much

[Freaky_zoid]

Hello Sandeep, could you please give a part of your table?
in your example it is not obvious (for me), which values are in which columns

[sweep]

Hi,

The following ARRAY formula will exctract a numerical fragment from cell A2.

Please Login or Register  to view this content.

Please modify as you require.

An array formula must be entered using CTRL, SHIFT and ENTER.

[sandeephg]

Please find attached file for better understanding

[sweep]

This does exactly what your example requests.

Hi,

The following ARRAY formula will exctract a numerical fragment from cell A2.

Please Login or Register  to view this content.

Please modify as you require.

An array formula must be entered using CTRL, SHIFT and ENTER.

[DonkeyOte]

Sweep your's didn't work for the last one (for me at any rate).

A non-array approach - not mine - Richard Schollar's

Please Login or Register  to view this content.

For the 2nd number - assuming it is at the end of the string and is always preceded by " TO " then you could use

Please Login or Register  to view this content.