Check for text in next cell, if none, add "and" to result

[babs43]

Happy Friday, all -

I have several columns which may contain text and I would like to add "and" before the last item.

Currently, I have

This	That	The other thing		This, That, The Other Thing
Tweedle Dum	Tweedle Dee			Tweedle Dum, Tweedle Dee

<tbody>
</tbody>

using the TextJoin join function. I would like to add "and" to the last item:

This	That	The other thing		This, That, and The Other Thing
Tweedle Dum	Tweedle Dee			Tweedle Dum and Tweedle Dee

<tbody>
</tbody>

Yes, I use the Oxford Comma I've tried nesting if statements, but I get stuck with "is blank" and so forth. Ideas?

 

[babs43]

Brilliant! Thank you! Yes, I suppose I can survive without the comma..... somehow I will manage.
b

 

[Eric W]

Hi Babs!

Yes, you're tough, you'll survive!

Glad I could help!

-ew