Firstly, posting in CAPITALS is considered SHOUTING and the post is often
ignored.

Secondly, try the solution below. It assumes your original data is in A1.

=LEFT(A1,6) gives the first 6 characters
=RIGHT(A1,LEN(A1)-6) gives everything after the first 6 characters
--
Ian
--
"GRYSYF" wrote in message
...
I HAVE STYLE NUMBERS THAT HAVE UP TO 11 CHARACTERS
BUT I NEED TO SEPERATE THEM AS 6 IN THE FIRST FIELD AND THE BALANCE OF 1,
2,
3, 4, OR 5 CHARACTERS IN THE 2nd FIELD.
EXAMPLES:
123456BLUE = 123456 BLUE
123456BLACK = 123456 BLACK
123456ASST = 123456 ASST