How to use if condition to for this ...

LearnerExcel · #1 12-19-2016, 02:04 PM

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.

LearnerExcel · #2 12-19-2016, 02:14 PM

Got it. The below function works fine:

=IF(ISNUMBER(VALUE(LEFT(A1,1))),A1,"")

=IF(ISNUMBER(VALUE(LEFT(A1,1))),"",A1)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I sum values using SumIfs condition like ...	LearnerExcel	Excel	6	11-28-2016 09:45 PM
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else)	SoonerLater	Mail Merge	1	09-30-2015 05:40 PM
Find and replace condition	norgro	Word VBA	2	07-31-2015 06:38 AM
check with condition	karti	Word	2	03-15-2011 06:06 AM
Retrict Method Condition	markp	Outlook	0	12-22-2005 05:38 PM