Forum Discussion

Yomnaehab's avatar
Yomnaehab
Copper Contributor
Jun 07, 2023
Solved

Extract characters from string

Hello. in the screenshot i have column with data and i want to extract the number before MW. the character length is not constant and location of the numbers as well. would appreciate any help usin...
BI & Data Analysis
excel
Formulas and Functions
  • ExcelExciting's avatar
    ExcelExciting
    Jun 07, 2023

    Hi Yomnaehab 

     

    Here you go with the updated file version now returning zero

     

    Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget to mark it as Official/Best Answer to help the other members find it more

ExcelExciting's avatar
ExcelExciting
MVP
Jun 07, 2023

hi Yomnaehab, 

 

Here is the solution file you might need to try with your dataset

 

 

Steps:

1. remove the spaces between MW

2. Extract Only MW

3. Merege source table to MW

 

Here are the Query Dependencies that might be helpful to understand

 

 

Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget to mark it as Official/Best Answer to help the other members find it more

Resources