Thread: specific data

Hi all, I have a column of over a 1000 account numbers , some of then end in C.
I would like to filter out these values into a separate column . for eg
IF last character = C then insert value else blank.
Thanks for you r help again, everyone.
--
delmac

Say your column is A, then insert this formula in an unused column, row 2,
and drag down as necessary:
=IF(RIGHT(A2,1)="C",A2,"")

Regards,
Stefi


„delmacâ€� ezt Ã*rta:

> Hi all, I have a column of over a 1000 account numbers , some of then end in C.
> I would like to filter out these values into a separate column . for eg
> IF last character = C then insert value else blank.
> Thanks for you r help again, everyone.
> --
> delmac