Thread: Trimming text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scott scott is offline
external usenet poster
 
Posts: 577
Default 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