Data Wrangling

[sv11]

Hi,

I have a column with phone number data with multiple formats as shown below:

I would like to clean and transform this data into a single format.

Any suggestions on how can I achieve it in power query?

Appreceate the help.

Thanks

[bogomda]

see a link to excel file with two different solutions:

https://1drv.ms/x/s!AhUWZ84uo7UAglmVqp3zaTO6SmEK

[tarunsingla]

Try this:

Add a custom column to select only the digits from the string column, like this:

Text.Select([Column1], {"0".."9"})

Then assuming phone numbers will be all 10 digit long, transform the newly added custom column to extract the first 10 characters.

Regards,

Tarun

Did I answer your question? Mark my post as a solution!

[tarunsingla · Accepted solution]

Hi @sv11, Did my response help? Could you please accept the response as a solution if it did.