vlookup last character of 102 char field
 

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

vlookup last character of 102 char field
 

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" wrote:

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

vlookup last character of 102 char field
 

Thanks JMB, It works great.

vlookup last character of 102 char field
 

Good to hear.

"splat" wrote:

Thanks JMB, It works great.