Three questions

1. I have a list of about 19,000 lines long, one column. The numbers all
start with a w or a c and are followed by 5 digits. I need to get the w or c
off of this column.

2. This coilumn has a lot of repeats in it. How do I get this doen to
unique values only?

3. I need to compare the items in this column to another column to make
sure the numbers are there. How do I verify, for instance, whether or not A1
is in B:B?