How to use if condition to for this ...
How to write a function like below:
=IF(LEFT(A1,1)="4","",A1)
Instead of 4, I would like to say, if its is an Alphabet (A-Z)
For second to get numbers ....
Instead of 4, I would like to say here, if its is a Number (0-9)
Because I have to segregate it based on first character of a cell.
|