Forum Discussion
dadafox78
Feb 27, 2019Copper Contributor
formula
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
- 0rtliCopper Contributor
=IF(ISNUMBER(A1)=FALSE,A1,"")