Good day to all,

I get a daily spreadsheet report that contains transaction numbers on
one of the columns. I need to delete transactions that ends with the
letter "C". For example, W00121212C or T00004578C or D00000023C

The normal transaction number starts with a letter then 8 numbers. If
the transaction was corrected for error then our software adds a "C" at
the end of the transaction number to indicate that correction was done.


However I need to generate a report on all the transactions but not the
corrected ones.


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=495262