Forum Discussion
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...
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
What about the data when there is no MW written next to it ? could you please attach sample file to work on this query.
Regards, Faraz Shaikh
Regards, Faraz Shaikh
- I want it to return 0 when there's no MW
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
- this worked thank you so much!
