Test if Last Character in Column of Cells is Alpha Character
Try the below
Sub Macro()
If Right(Trim(Range("A1")), 1) Like "[A-Za-z]" Then
MsgBox "Alpha"
End If
End Sub
If this post helps click Yes
---------------
Jacob Skaria
"Benjamin" wrote:
How do I test if the last character in Column A is a Alpha Character
Sample cell: 0238:H601X or 0238:T0624
the numbers in the cell still will show up as Text format.
How can I do an excel formula or VBA to give me a true/false if the last
character is an alpha(letter)?
|