• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel formula to format phone numbers and Mobile numbers

Madhuri_G

Member
Hellow people,

Can someone show me light on how to format Mobile and Phone numbers Column A & B
Please see attached
The red coloured ones are incorrect format so need be splitted into 0422 567 345(Mobile number) and Phone should be formatted into 02 5678 3456(Phone)

Please help!!
 

Attachments

  • Ph numbers_incorrect format_v1.csv
    157.5 KB · Views: 9
Hi, since it is a csv, you can use this procedure
1. On the data ribbon, use Get External Data from Text.
2. Follow along with the guided steps,
3. use the correct delimiter, being ","
4. highlight each column and define as text, before pressing Finish.
 

Attachments

  • textImport.xlsx
    55.5 KB · Views: 6
Back
Top