View Single Post
 
Old 12-19-2016, 02:04 PM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2003
Advanced Beginner
 
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default 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.
Reply With Quote