formula

Copper Contributor

Hi,
I need to extract all the numbers from the column that contains the text as well.

For example:

Andrea
1,3
winter
12:20
Roman
3,2
12:40

I need extract to another column only 1,3 and 3,2 without names and times.

1 Reply

=IF(ISNUMBER(A1)=FALSE,A1,"")