Bonjour,
je te propose le code suivant
=SI(A2<>"";"'"&A2&"'";"") & SI(B2<>"";",'" &B2&"'";"")& SI(C2<>"";",'" &C2&"'";"")& SI(D2<>"";",'" &D2&"'";"")& SI(E2<>"";",'" &E2&"'";"")& SI(F2<>"";",'" &F2&"'";"")& SI(G2<>"";",'" &G2&"'";"")& SI(H2<>"";",'" &H2&"'";"")& SI(I2<>"";",'" &I2&"'";"")& SI(J2<>"";",'" &J2&"'";"")
Attention, le première SI diffère des suivants