Forum Discussion
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)) Th...
Hi
=IFERROR(RIGHT(O10,LEN(O10)-SEARCH(" ",O10,1)),RIGHT(B2,LEN(B2)-SEARCH(" ",B2,1)))
- Thanks!
