Replace Function problem

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.

Please Login or Register  to view this content.

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..

Please Login or Register  to view this content.

=AnaSort("987654") returns "456789"

My take on it:

Please Login or Register  to view this content.

NUMBER = 123456

=RIGHT(A1,1) would give you the last digit in cell A1. =6 (but we don't need that)
=LEFT(A1,2) would give you the first TWO digit in the cell A1. =12

Now for the fun, I want the last digit from the LEFT formula, so I snug them together:
=RIGHT(LEFT(A1,2)) - result =2 (the second digit)

Now I concatenate the original first digit after that:
=RIGHT(LEFT(A1,2))&LEFT(A1,1) =21

Then, I figure out how many numbers were left over using a LEN formula
=LEN(A1)-2) ..the -2 is to remove the first two digits I've already calculated above. =4

Now I know how many digits are left over, so I concatenate them on to the end with a RIGHT function:
RIGHT(A1,LEN(A1)-2) ...which adds on like so:
=RIGHT(LEFT(A1,2))&LEFT(A1,1)&RIGHT(A1,LEN(A1)-2) =213456

Now, the only left to do was put your MID test back on as an opening IF test, if true, the formula we constructed, if false, an A1 tacked onto the end.

Please Login or Register  to view this content.

Personal preference, using the LEFT/RIGHT combo or RIGHT/LEFT combo trick to get a particular digit out of the middle of a string is easier for me to do than the MID formula, which I know is the preference of many others.

Thanks alot for your wonderful explanation...Im learning something new day by day on Excel..Its really interesting and it do amazing things..

newbie, please don't quote whole posts. It just clutters the forum.