anyone know how i can write a formula that would extract part of a word from
a cell, but if doesn't have the word it returns anything but a #VALUE!?

Ex: Afghanistan
Afghanistan - Cellular
So the formula would return a 1 or 0 or anything but #Value! and the second
would return the wor cellular. The list would would go down so next would be
let's say:
American Samoa
American Samoa - Cellular

Again, 1st would return anything and second would return cellular

Thanks.