filter a list

  • Thread starter Thread starter L.J.
  • Start date Start date
L

L.J.

Hi all,

In the "City" column, we type city with capital case in order to identify
the donors. Now I need to mass mailing to the donors only. Is there any
possibilty that I can filter all cities typed with "cpital case"?

Thanks in advance for your help!

Regards,
L.J
 
Add a new column to the table, with the heading "Donor"
In the cell below the heading, enter the formula:
=EXACT(D2,UPPER(D2))
where city is in column D
Copy the formula down to the last row of data
Filter the table for TRUE in the Donor column.
 
Back
Top