I have a list of random numbers generated by excel. I now want the same list
of nine digit numbers to all end in 1. EG 255254456 to become 255254451 is
there a way i can do this in excel?