Or try in F2 and copy down:Formula:
=LET(t,TEXTJOIN(", ",,C2:E2),B2&" "&IFERROR(REPLACE(t,1+LEN(TEXTBEFORE(t,",",-1)),1," and"),""))
Or try in F2 and copy down:Formula:
=LET(t,TEXTJOIN(", ",,C2:E2),B2&" "&IFERROR(REPLACE(t,1+LEN(TEXTBEFORE(t,",",-1)),1," and"),""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks