|
'--------------------------------
Sub remove_alph_from_right()
'--------------------------------
Dim rngX As Range
'조직도 범위
Set rngX = Range("A1:M200")
' 이름 범위
Set rngX = rngX.SpecialCells(xlCellTypeConstants)
Dim rngY As Range, v As Variant
Dim c As Long
' 각 Area를 돌려
For i = 1 To rngX.Areas.Count
Set rngY = rngX.Areas(i).Cells(1)
v = rngY.Value
'마지막 글자가 알파뱃이면
If Right(v, 1) Like "[A-Za-z]" Then
rngY.Value = x(v)
End If
Next i
End Sub
'---------------------------------
Function x(v)
'---------------------------------
' 글자 수만큼 루핑
For m = 1 To Len(v)
' 알파벳을 만나면
If Mid(v, m, 1) Like "[A-Za-z]" Then
Exit For
End If
Next m
'알파벳이 아닌 글자만 리턴
x = Left(v, m - 1)
End Function
|
|