Cleaning Data Set

[JingYih_Herbalife]

I have this set of data with mobile numbers that are not organized.

I want to sort out the data, by removing all symbols, and separating all the mobile numbers into multiple columns as per below;

Appreciate some help on this.

[AlexEntz · Accepted solution]

Hello JinYih,

you can seperate the telephone numbers by using the text to column function. The Delimeter is "/" in your case.

To remove the parenthesis you have to use the formula tool and then the expression: trim(Mobile Number, "(") then use another expression: trim(Mobile Number, ")").

Hope this helps. Please provide an excel sheet with data if you wish for me to create an example workflow.

Greetings Alex

[JingYih_Herbalife]

Thank you for your prompt response. This helped 🙂