Hi Mac101:Originally Posted by MAC101
Welcome to the Board!
Let us say the entry in cell A1 is 11122222333 -- then to split it into 3 different strings as per your specification, use the following formulas ...
in B1 ... =LEFT(A1,3) ... that will give us 111
in C1 ... =MID(A1,4,5) ... that will give us 22222
in D1 ... =MID(A1,9,3) ... that will give us 333
then copy the formula in cells B1:D1 to B2:D2 through B100:D100
If you have a large number of such cells to convert, then a macro can be written to do the comversion with a single click of the button.
Does it help?