Hi again

Put this on the sheet where you want the even numbers and drag down.
=IF(MOD(LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,2)=0,LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,"")

and for the odd numbers
=IF(MOD(LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,2)=1,LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,"")

In both case mind the line wrap it's a single line. you will get gaps but
these will dissappear when you sort the data.

Mike


"K Drier" wrote:

This is a second function to a prior question wherein we removed an alpha
character from the end of a number down the full length of a column. Now
they want me to sort these data into even and odd numbers and copy them and
their correspondending data to another worksheet.

Is there a way to add these two functions to the following formula?

=LEFT(A1,LEN(A1)-1)+0


You all are wonderful... I've been away from Excel for years and have
forgotton even the basics of writing forumlas and macros. Back to the books !

Thanks so much!