Microsoft Office Forums - View Single Post - [Solved] How to use if condition to for this ...

Thread: [Solved] How to use if condition to for this ...

View Single Post

Old

12-19-2016, 02:14 PM

LearnerExcel LearnerExcel is offline

LearnerExcel is offline

LearnerExcel uses Windows 7 32bit

Windows 7 32bit LearnerExcel uses Office 2003

LearnerExcel uses Office 2003

Office 2003

Advanced Beginner

The original poster

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

LearnerExcel will become famous soon enough

Default

Got it. The below function works fine:

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

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

Reply With Quote