=MID(A1,FIND("-",A1)+1,255)

and copy down.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Scott" wrote in message
...
I need some help trimming text.

Dilemma: I want to remove the number coding in front of the state code so
that in column B in range B1:B3, I have California/Ohio/Maryland without
the
numbers. How do I trim the first four characters in the cell range A1:A3?

Col A
001-California
002-Ohio
003-Maryland

Col B - desired result
California
Ohio
Maryland