Oh, beautiful! It worked! Thanks so much!
I created another A1 column to the left to contain the formula and
referenced the B1 cell and it worked! How fabulous is that! Thanks thanks
thanks!
Kirsten


"Bernard Liengme" wrote:

If the first street NUMBER is in A1 use =ISEVEN(A1) this will given either
FALSE or TRUE
On the other hand, --ISEVEN(A1) {that is two negative signs after the =
sign} will give 0 or 1
Copy down the column and not you can sort
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kirstensaid" wrote in message
...
A previous post covered this but I need a bit more help to complete the
task.

I have a list of addresses, formatted with the street number and street
name
in separate columns. I need to keep the even-numbered addresses and
discard
the odd-numbered ones.

The previous question came up with an answer using the ISEVEN formula but
I
think I'm inputting it incorrectly or placing it in the wrong location. If
you can help, please be as specific as possible as I'm not using Excel
formulas every day and have to walk myself through them when I do.

Thanks!
Kirsten