I find the easiest way is to double up on the quotes to handle a quote. Some people like to use CHR(34)*: In this sample, the formula will check if D2 contains a space or not, Like ” ” and then decide which calculation to apply.
I find the easiest way is to double up on the quotes to handle a quote. Some people like to use CHR(34)*: In this sample, the formula will check if D2 contains a space or not, Like ” ” and then decide which calculation to apply.