Hello,

I have a list of about 300 names that I want to shorten.
I want to use a combination of the mid and find function, but I don't know
what wildcard to use for numbers.
What formula can I use for the original text below to get the result that I
want?

Hope you guys can help, I can't find any solution at all!

Original Text Result
ROCK SPIKE 9 LAND&SEA ROCK SPIKE
BOOT COMFORT NON-ZIP 12 LAND&SEA BOOT COMFORT NON-ZIP
BOOT BEACH ZIP NEO 9 LAND&SEA BOOT BEACH ZIP NEO