Fixing inconsistently formatted Australian mobile numbers… in excel! 😎

Here is the excel formula:

=IF(LEFT(M2,1)="0", "+61"&RIGHT(M2,LEN(M2)-1), IF(LEFT(M2,3)="+61", M2, "+61"&M2))

This formula checks if the first character of cell M2 is 0. If it is, it concatenates “+61” with the rest of the characters in M2 except the first one. If not, it checks if the first three characters of cell M2 are “+61”. If they are, it returns M2. If not, it concatenates “+61” with M2.

Hope it helps! 😀