Trying to find an "A" in the last position of a variable length Part Number in Cell

[tbroniecki]

Trying to find an "A" in the last position of a string

In my worksheet I have a column that contains a Part Id. This part id is alphanumeric and has a variable length. I would like to identify those part ids that have an "A" in the very last position of the Part Id.
How can I identify the "A" in this string within my Excel Macro?

Is there a way I can LOOK at the data in the Cell from RIGHT to LEFT and pickup and identify the first character (right-to-left) that has an "A" in the first position. I tried using RIGHT & FIND as an option but not sure how to combine them.

I Store the Part Id found in te Cells I reviewl in a String defined as i.

The ones I wish to identify are Bolded.

096SD_A
STMX1450A
330000000
550000000
550000000A
96519590
1965195901A
965195901E
96519590
2965195902A
DTXA

 

[tbroniecki]

Ted to himself.


I was able to achieve the result doing the following:

vPrdId is the String containing the ProdId

vLastChar = RIGHT(vPrdId, 1)

This looks at the Data from the Right hand Side and returns the first Character.