Thanks Leith!

One minor problem regarding (3). I tried to formating the worksheet as
TEXT, but because the numbers have a unique form of "*011" with the
asterisk infront, performing a text to column action on the selected
column will automatically transform the *011 to 11 only.

Would appreciate any help on this, very near to the completion of the
macro. Thanks again!