View Single Post
  #1   Report Post  
Mike R
 
Posts: n/a
Default Split off numbers

I have about 100 sets of numbers in column I,i.e. 1513-345678, and I want to
pull off the first four and the "-" from the rest of the set and place them
in column H. What is a formula that will do that for me?

Mike Rogers