# EXTRACT TEXT AND NUMBER IN EXCEL VBA CODE (DESCRIPTION ⬇️)
Автор: CHAUDHARY ZUEHB
Загружено: 2025-01-03
Просмотров: 18
Описание:
EXTRACT TEXT AND NUMBER IN EXCEL
VBA CODE
Function ExtractNumbers(Value As String)
Dim StrLength As Integer
StrLenth = Len(Value)
Dim i As Integer
Dim NumbericChars As String
For i = 1 To StrLength
If IsNumeric(Mid(Value, i, 1)) Then NumericChars = NumericChars & Mid(Value,
i,1)
Next i
ExtractNumbers = NumericChars
End Function
Function ExtractText(Value As String)
Dim StrLength As Integer
StrLenth = Len(Value)
Dim i As Integer
Dim TextChars As String
For i = 1 To StrLength
If IsNumeric(Mid(Value, i, 1)) Then TextChars = TextChars & Mid(Value, i, 1)
Next i
ExtractText = TextChars
End Function
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
