Question : extract number from string excel
Answered by : md-faysal-ahmed
Function GetNumeric(CellRef As String)
Dim StringLength As Integer
StringLength = Len(CellRef)
For i = 1 To StringLength
If IsNumeric(Mid(CellRef, i, 1)) Then Result = Result & Mid(CellRef, i, 1)
Next i
GetNumeric = Result
End Function
Source : https://trumpexcel.com/extract-numbers-from-string-excel/ | Last Update : Fri, 19 Aug 22
Question : extract numbers from string excel
Answered by : md-faysal-ahmed
Function GetText(CellRef As String)
Dim StringLength As Integer
StringLength = Len(CellRef)
For i = 1 To StringLength
If Not (IsNumeric(Mid(CellRef, i, 1))) Then Result = Result & Mid(CellRef, i, 1)
Next i
GetText = Result
End Function
Source : | Last Update : Fri, 19 Aug 22