Trimming text
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
|