• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Query m Code to Extract Call Number

Status
Not open for further replies.

Sanket Katdare

New Member
Hi There,

I am looking for Excel Power Query M Code which will to segregate case numbers in two different columns as per their type.
Also, there might be some free text available in few case numbers, wanted to remove those unwanted characters and extract correct call number

Sample Input Table
Number
183461-1000754
183461-1001042
183461-1001069
183461-1001152
183490-1000647 Complaint
60-0032745101
60-0032819228
60-0032827919
60-0032829170 Demo

Expected Output
CaseNo
183490-1000647
183461-1000754
183461-1001042
183461-1001069
183461-1001152
60-0032829170
60-0032745101
60-0032819228
60-0032827919
 
Sanket Katdare
Please, do not duplicate Your thread
You can continue with Your original
This duplicated thread is closed.
 
Status
Not open for further replies.
Back
Top