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.
Solved! Go to 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
Thank you for your prompt response. This helped 🙂