Separate numeric/text combination into two separate columns.

You can use Data | Text-to-columns, with a fixed width for the first field of 3 characters.

Hope this helps.

Pete

to get the number (any digits)
=LEFT(A1,SUMPRODUCT((ISNUMBER(--MID(A1,ROW($1:$10),1))*1)))
to get the text
=SUBSTITUTE(A1;LEFT(A1;SUMPRODUCT((ISNUMBER(--MID(A1;ROW($1:$10);1))*1)))

Well, we can only go off the examples you have given, which all show 3 numeric digits. If your data is all like that then you can put this in B1:

=LEFT(A1,3)*1

where the *1 will convert the text values into numbers - omit that if not required.

Then in C1 you can have this:

=SUBSTITUTE(A1,B1,"")

Copy both down as far as you need to.

If you want only those two columns, then fix the values in columns B and C using copy | paste special | values | OK then <Esc>, and then delete column A.

Hope this helps.

Pete