vlookup last character of 102 char field

[splat]

Hi All,

I have a data field that has codes that are 102 characters long. 62000
different ones. I need to remove the ones that do not end with A and
C.

........359CXAPA I would need to keep in the list
........468CYBMR I need to remove from the list

What would be the best way to do this?

Thanks
Owen

 

[Guest]

If your data starts in B2, enter this in A2 and copy down

=OR(RIGHT(B2)={"A","C"})

Then use autofilter on column A to filter for FALSE and delete the rows.
Then turn off autofilter.

 

[splat]

Thanks JMB, It works great.

 

[Guest]

Good to hear.