View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
splat splat is offline
external usenet poster
 
Posts: 22
Default 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