Hi Larry ,
I do not know what you wish to do.
I can explain what the macro does.
The macro is to be called as follows :
=MYSPLIT(range which contains the number , position of digit which is to be returned , position from where the counting is to start)
Thus , let us assume there is a 5 digit number , but you want only the right-most 4 digits to be returned in their separate cells. Thus , in the 4 cells , you would have the following 4 formulae :
=MYSPLIT($A3,1,2)
=MYSPLIT($A3,2,2)
=MYSPLIT($A3,3,2)
=MYSPLIT($A3,4,2)
Because we do not want to enter a different formula in each cell , we use the COLUMN function , which will change appropriately as we copy the formula across :
=MYSPLIT($A3,COLUMN(A3),2)
However , when you have only a 4-digit number , which is to be separated , then in the 4 cells , you need to have the formulae :
=MYSPLIT($A3,1,1)
=MYSPLIT($A3,2,1)
=MYSPLIT($A3,3,1)
=MYSPLIT($A3,4,1)
To avoid entering a different formula in each cell , we now need to use :
=MYSPLIT($A3,COLUMN(A3),1)
Narayan