Excel Replace Items
Posted on 2011-03-14
Can someone please tell me if it possible to replace more than one item in excel?
For example, if I wanted to replace the numbers 5,4,3,2,1 with 1,2,3,4,5 can I do that in one shot?
At the moment, I would have to replace 5, with 1, then go back in and replace 4 with 2 etc...