נוסחת הוספת 0 למספרי טלפון באקסל

PHOTO EMBED

Thu Jun 30 2022 14:52:40 GMT+0000 (Coordinated Universal Time)

Saved by @Shesek

=IF(LEFT(TRIM(G2),1)="+","0"&MID(G2,5,10),(IF(LEFT(TRIM(G2),1)<>"0",IF(LEFT(TRIM(G2),3)="972","0"&MID(G2,4,10),"0"&G2),G2)))
content_copyCOPY