I am looking for a solution regarding eliminating of characters in a column.
There are 3 columns in a worksheer
SerialNo,Mobile number and text.
In the Mobile number column it should contain only 12 digit numbers alone neither it should have length < 12 nor > 12 and only number should be allowed in this columns.
how do i sort such columns when the column has around 1,00,000 rows of data.
with mix of different characters [like -,),( ]?
could any1 provide me the solution.