Description

Nowadays we use a lot of back end software and tools which throws mixed raw data that needs to be separated further to generate some kind of report. The major challenge here is that the raw data doesn’t has uniformity. When Numbers & Characters comes together in mixed way then its very difficult to separate them because there is no uniformity in data, i.e. EXC28EL,E28XCEL,EX28CEL,2EX8CEL & EXCE28L etc. It is very difficult
for a user to extract Number & Character separately from these data by any Excel function.