Split column by count of characters Excel 2003?

Question

how can I split column by count of characters, I have a big file with addresses and I need to take the zip code and state in the own column and I do not want to retype the whole thing, I know there is a formula to take the last 5, or any other number, characters of one column and place them in the next column, I already tried text to columns but it does not work for this, please help!

Answer 1

The question is confusing, but if you want the the state, a space and the first 5 of the zip:

State in column A, whole zip in column B, result in column C:

In C1:

=CONCATENATE(A1," ",LEFT(B!,5))

Autofill this down the column.  Email me if you need more.