How can I detect if a character in a string is a letter or a number.

[interner]

Not an actual question, was getting no results in searching for the answer on the internet, but I figured it out! Maybe it can help someone along the way. Please don't punish me for posting a answer.

[/code]
Sub stringnumtest()
Dim thatsaletter As Boolean
somestring = "2p"
thatsaletter = IsNumeric(Right(somestring, 1))
If thatsaletter = True Then
MsgBox "yes"
Else
MsgBox "no"
End If
End Sub

You could obviously use any variation of string handling where the "right" function exists. Happy Friday!

 

[bertie]

Here is something else you can play about with if you need to be more specific.

Each character has an ASCII number.
http://www.asciitable.com/

33-47.....Special characters
48-57.....numeric 0-9 inc
58-64.....Special characters
65-90.....A-Z upper case
91-96.....Special characters
97-122....a-z lower case
123-126

You could write a Function, containing a Select Case statement, returning a string denoting the type of character.

Just saying, like.

Bertie