Help EXCEL

[nukpana]

sa expert po dyan sa excel. may way ba na maigroup yung magkakasunod na data ng madalian? whole 2023 kasi yung data . salamat po

 

[_gHe]

lods kaylangan tangalin muna yung letters?

Pwede paLa,..
kanina kasi pag try ko hindi nagana,..
check mo na Lang to

 

[nukpana]

salamat ng marami lods. napaka buti mo

 

[jhan04]

ok na ba ito master?

 

[nukpana]

ok na ba ito master?

ok na to master

 

[GMFroilan]

Send mo Actual File sakin Brad. Gawan natin ng formula pero sa new sheet yung result

Function StripChar(aText As String)
Dim I As Integer

StripChar = ""
For I = 1 To Len(aText)
aChar = Mid(aText, I, 1)
Select Case aChar
Case "0" To "9"
StripChar = StripChar & aChar
End Select
Next
End Function

Function StripChar(aText As String)
Dim I As Integer

StripChar = "0"
For I = 1 To Len(aText)
aChar = Mid(aText, I, 1)
Select Case aChar
Case "0" To "9"
StripChar = Val(StripChar & aChar)
End Select
Next

End Function

 

[nukpana]

Send mo Actual File sakin Brad. Gawan natin ng formula pero sa new sheet yung result

Function StripChar(aText As String)
Dim I As Integer

StripChar = ""
For I = 1 To Len(aText)
aChar = Mid(aText, I, 1)
Select Case aChar
Case "0" To "9"
StripChar = StripChar & aChar
End Select
Next
End Function

Function StripChar(aText As String)
Dim I As Integer

StripChar = "0"
For I = 1 To Len(aText)
aChar = Mid(aText, I, 1)
Select Case aChar
Case "0" To "9"
StripChar = Val(StripChar & aChar)
End Select
Next

End Function

naka total na ba yung magkakagroup dol?