View Single Post
  #2   Report Post  
Bob Umlas
 
Posts: n/a
Default

=MID(A1,5,255)
If the result is numeric for sure, you can use
=1*MID(A1,5,255)
or
=MOD(A1,100000)

Bob Umlas
Excel MVP

"MFreeman" wrote in message
...
How do I remove the 1st 4 characters of a field in Excel?