❓ Help EXCEL

Status
Not open for further replies.

nukpana

Established
sa expert po dyan sa excel. may way ba na maigroup yung magkakasunod na data ng madalian? whole 2023 kasi yung data . salamat po
 
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
 
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?
 
Status
Not open for further replies.

About this Thread

  • 26
    Replies
  • 2K
    Views
  • 7
    Participants
Last reply from:
sheilramzkie

Trending Topics

Online now

Members online
417
Guests online
13,240
Total visitors
13,657

Forum statistics

Threads
2,362,230
Posts
29,414,826
Members
1,056,918
Latest member
b00r4t
Back
Top