Hi, how would I list cell values separated by comma, but for the last value separated by the word "and".
For example, 'Apple, Orange and Pear'.
If the third cell is empty, then 'Apple and Orange'.
Thank you.
Best answer by Troy Tessalone
View original