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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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