Apply data|Filter|Autofilter to that column.

Then Custom filter to show:
Ends with
(type c)

Then delete the visible rows.

(I like to keep the data, but use a filter hide those rows ("does not end with"
with c).)

ledzepe wrote:

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

--

Dave Peterson