Splitting Names

Hello, is it possible to run this formula  =RIGHT(N10,LEN(N10)-SEARCH(" ",N10,1)) and if it shows an error #VALUE! run an alternative version of the formula =RIGHT(B2,LEN(B2)-SEARCH(" ",B2,1))

Thanks,