Excel Help Home ExcelHelp.com BBB Business Review
Excel IsNumeric Function

 

Excel IsNumeric Function

 

 

The IsNumeric Excel Function is used to determine whether or not a specific value is a numerical value or not. The IsNumeric function also returns a Boolean value (True or False).

 

 


 

 

The Basics:

 

 

True/False = IsNumeric(ValueToBeEvaluated)

 

 

 

Now. let us look at an example. Let’s assume that we want to parse a block of data and extract all numerical values and write the values out to a spreadsheet. The IsNumeric function be our tool to achieve this.


 

 

 

Code

 

 'Declare variables

Dim StringToProcess As String   'Variable string to process

Dim arrValues() As String       'String Array

Dim A, B As Long                  'Value to use as a counter

Dim tmpValue As Variant

Dim Check As Boolean

 

 


StringToProcess = ActiveSheet.Cells(2, 1).Value 'Assign the information to process to our variable

 

 


arrValues() = Split(StringToProcess, " ") 'Parse the string into a string array using a space delimiter

 


Counter = 5

 


For A = LBound(arrValues) To UBound(arrValues)

 

Check = IsNumeric(arrValues(A))


 

 

If Check Then


 

ActiveSheet.Cells(Counter, 1).Value = CDbl(arrValues(A))

Counter = Counter + 1


 

End If


 

 

 

Next


 

 

Output

 


 


 

 

 
 
Sitemap | Privacy | Terms
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation.
Copyright 2011 ExcelHelp.com All rights reserved
More Info (+)