I have a list of values and some might contain symbols, other might contain letter. See example below. How can I flag a value when it's not a number? Column a is the original column. Column B is the new column where only when column a is a number then column b will also be populated with the same value as column a. If column a is not a number or contain symbols or letter then column b will be blank. Will appreciate any inputs! Thank you!
a | b |
10 | 10 |
0.123 | 0.123 |
> 100 | |
100 ul | |
< 200 | |
563.25 | 563.25 |
1245.13 | 1245.13 |
1000 | 1000 |
10.09090909 | 10.09090909 |
-1191 | -1191 |
N/A | |
~4 ml |