formula

dadafox78
Occasional Visitor

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,"")

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies