Hi,

Not sure about a formula. But you can have a code to do it.
You mention the first 7 characters. Do you really want to remove from the first "-" to the beginning of the text?

Ie "44107-"

To let you know I'll be gone in about 5 minutes. If you do not receive an answer while I'm gone I'll take a look when I get back.