There are two ways of converting an 04 number to +61. For both you will need to make sure that you are working out of Microsoft Excel and that your worksheet is in text format and not general or number.


Please keep in mind that there will be a lot of variables with each new data set and there may be additional steps to this process.

Use a formula to add +61 to the start of the number

  1. Have a column with +61
  2. Have a column with your mobile numbers
  3. Use the formula:

    =CONCAT(A1,"",(MID(B1,FIND("0",B1)+1,255)))

    image.png

  4. If you already have the zero removed use this formula:

    =CONCAT(A1,"",A2)

    image.png

Use flash fill

  1. Have all mobiles in one column
  2. In the second column type 3 rows of what you want to achieve

    image.png

  3. Click anywhere in that same column
  4. Press Data>Flash Fill
    image.png