DOSYA İndirmek/Yüklemek için ÜCRETLİ ALTIN ÜYELİK Gereklidir!
Altın Üyelik Hakkında Bilgi
Sub HARF_RAKAM_AYIR()
Dim sh As Worksheet, hc As Range, ss As Integer
Set sh = ThisWorkbook.ActiveSheet
ss = sh.Range("A:D").Find("*", , , , xlByRows, xlPrevious).Row
For i = 2 To ss
Set hc = sh.Range("A" & i)
For d = 1 To Len(hc.Value)
If IsNumeric(Mid(hc.Value, d, 1)) = False Then
harf = harf & Mid(hc.Value, d, 1)
End If
If IsNumeric(Mid(hc.Value, d, 1)) = True Then
rakam = rakam & Mid(hc.Value, d, 1)
End If
Next d
hc.Offset(0, 1).Value = harf
Columns("C").NumberFormat = "@"
hc.Offset(0, 2).Value = rakam
harf = ""
rakam = ""
Next i
MsgBox "işlem tamam", vbInformation, "işlem sonucu"
End Sub
Dim sh As Worksheet, hc As Range, ss As Integer
Set sh = ThisWorkbook.ActiveSheet
ss = sh.Range("A:D").Find("*", , , , xlByRows, xlPrevious).Row
Dim ptr_1 As Integer
Dim ptr_2 As Integer
ptr_1 = 1
ptr_2 = 1
For i = 1 To ss
Set hc = sh.Range("A" & i)
If IsNumeric(hc.Value) Then
Sayfa1.Range("B" & ptr_1).Value = hc.Value
ptr_1 = ptr_1 + 1
Else
Sayfa1.Range("C" & ptr_2).Value = hc.Value
ptr_2 = ptr_2 + 1
End If
Next i
MsgBox "işlem tamam", vbInformation, "işlem sonucu"
Dim sh As Worksheet, hc As Range, ss As Integer
Set sh = ThisWorkbook.ActiveSheet
ss = sh.Range("A:D").Find("*", , , , xlByRows, xlPrevious).Row
Dim ptr_1 As Integer
Dim ptr_2 As Integer
ptr_1 = 1
ptr_2 = 1
For i = 1 To ss
Set hc = sh.Range("A" & i)
If IsNumeric(hc.Value) Then
Sayfa1.Range("B" & ptr_1).Value = hc.Value
ptr_1 = ptr_1 + 1
Else
Sayfa1.Range("C" & ptr_2).Value = hc.Value
ptr_2 = ptr_2 + 1
End If
Next i
MsgBox "işlem tamam", vbInformation, "işlem sonucu"