filter a list

[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

 

[Debra Dalgleish]

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.

 

[L.J.]

Dear Dalgleish,

Thanks so much for the prompt reply. You are awesome.

Regards,
L.J