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)?

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)?

You can use not isnumeric()

If not isnumeric(Right(Trim(Range("A1")), 1)) Then

or

If isnumeric(Right(Trim(Range("A1")), 1)) Then


The trim is needed if there may be blanks at the end of the string.


"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)?

An even simpler construction for the test...

Sub Macro()
If Range("A1") Like "*[A-Za-z]" Then
MsgBox "Alpha"
End If
End Sub

By the way, I removed the TRIM function call because that would mask the
fact that the string ended with something other than an alpha character.

--
Rick (MVP - Excel)


"Jacob Skaria" wrote in message
...
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)?

Yes; thereby can avoid the usage of RIGHT(); but hope the OP would want to
ignore any spaces at the end..

If this post helps click Yes
---------------
Jacob Skaria


"Rick Rothstein" wrote:

An even simpler construction for the test...

Sub Macro()
If Range("A1") Like "*[A-Za-z]" Then
MsgBox "Alpha"
End If
End Sub

By the way, I removed the TRIM function call because that would mask the
fact that the string ended with something other than an alpha character.

--
Rick (MVP - Excel)


"Jacob Skaria" wrote in message
...
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)?

YES! that worked so good! Just what I needed. Thanks Jacob!

"Jacob Skaria" wrote:

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)?

Just one follow up question. The formula, as Jacob has presented it to you,
will ignore all trailing blank spaces at the end of your text string... is
that acceptable to you?

--
Rick (MVP - Excel)


"Benjamin" wrote in message
...
YES! that worked so good! Just what I needed. Thanks Jacob!

"Jacob Skaria" wrote:

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)?