Ok so what I need to do is set up an If/then macro that will populate anywhere from 1-11 columns based on some previous calcuations done. I'm having trouble with the formatting though.

Im starting out with a number like 1001001164532, this is a Concatenated number that basically holds all the information about a person that I need tracked. Now these numbers can vary in length adding or subtracting at most 5 digits all taken from the right side and moving inward.

So ill have my 11 max columns (number above is one involving 6 columns needing to be populated.) I was going to start with a simple comparison of that number vs the baseline amount of digits so is 1001001164532 greater than 1000000000000, if it is then a formula to extract the specific digits I need. something like (MID($P2,4,1)&LEFT($P2,3))*1
If it failed the test then I want the cells to be blank.

Firstly I'd like to know if there is a command that will just count digits so I can say If X has so many digits then do the formula or make it blank?

Second I can't seem to get the formatting down to where it will actually populate the entire range of cells. I've tried Sheet4.CellsE:E but that does not work, I can't seem to find the proper format anywhere. Any help would be appreciated.