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)))
Copy this HTML code:
Preview:
open_in_newInstructions on embedding in Medium
Comments