A couple of folks helped me yesterday and I am very grateful. Now I
have another issue. The problem now is that I am merging two
different worksheets that were created by different users. One
entered a block of telephone numbers as simply a string of digits
(8005551212) and the other sheet has the phone number listed with
dashes separating the area code and first three digits
(800-555-1212). The problem comes in when sorting for the numbers.
The first group sorts out and then the second group sorts because of
the dashes. Is there anyway to make all of the data compatable one
way or the other without having to fat finger it all?

Thanks.