Hi guys again...Another small problem im face..hehe
I have this set of number..
987654.
What im trying to do is this..I read this number and check for the first number with the 2nd number. If its greater then i will swap it. Im trying to do this so that my number can be rearranged as 456789.
=IF(MID(A1,1,1)>MID(A,2,1),REPLACE(A1,1,1,MID(A1,2,1)),0)
As you see i tryied this code can replace the 2nd number to the first and i get 887654. How can i put 2 replace statements at the same time so that i can swap the 98 to 89...
Kinda confused...Anyone care to help out..
Bookmarks