G
gamouning
Hi,
I need to returns an empty or blank cell instead of "#VALUE!". I am
using the following formula to capture the last word:
=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1,"
","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
Thanks in advance for your assistance.
-Greg
I need to returns an empty or blank cell instead of "#VALUE!". I am
using the following formula to capture the last word:
=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1,"
","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
Thanks in advance for your assistance.
-Greg