Assume your entries are in col A. Use this in col B

=LEFT(A1,5)

Use this in col C

=TRIM(RIGHT(A1,LEN(A1)-5)))


"GRYSYF" wrote:

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