ش | ی | د | س | چ | پ | ج |
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 |
منبع : اینترنت
The following function helps Excel identify if a character is a special character, like #, @, and !
Function IsSpecial(strValue As String) As BooleanDim intPos As Integer(For intPos = 1 To Len(strValue(Select Case Asc(Mid(strValue, intPos, 1Case 33 To 47, 58 To 64, 91 To 96, 123 To 126IsSpecial = TrueCase ElseIsSpecial = FalseExit ForEnd SelectNextEnd Function