How to use if condition to for this ...

		Microsoft Office Forums > Microsoft Excel > Excel
How to use if condition to for this ...

12-19-2016, 02:14 PM

LearnerExcel LearnerExcel is offline

Windows 7 32bit How to use if condition to for this ...

Office 2003

Advanced Beginner

Join Date: Nov 2016

Posts: 82

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:19 AM.