Thanks for the response. You both nailed it for me. Some things that are so
simple can be so difficult to see. Thanks again.

Mike Rogers

"Mike R" wrote:

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