=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)))

downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter