Hi,& Welcome
sheet 1= cell b1 have number 8472156
b3 have number 74451
e5 have number 9840
i want sort auto generate this 3 cell number as small to bigger (0123456789)
example like to new sheet 2 answer is b1=1245678
b3=14457 and e5=0489
still now i am doing manual key the number to new sheet small to bigger..
Any Ideas ?
Bookmarks