Thanks to Mr. Delphenium Aura for the Question.
How can we extract numbers from a text? For example👇
( ra46j8u9 y%a7da54v )"
in our everyday work life, we face many issues related to databases where we have a mixture of text, numbers, special characters, etc. and we have to extract numbers from that text or string.
So I am going to explain it today video with 2 examples. must watch this video till the end to know in detail.
Functions used
#LEN, #INDIRECT, #ROW, #MID, #IFERRO, #TEXTJOIN, #ISNUMBER, #LARGE, #SUM
Lookup Functions 👉 https://youtu.be/ivzr8zbjyNE
Indirect Number 👉 https://youtu.be/gMD8SepX17E
ISNUMBER Functions 👉 https://youtu.be/oQmFI2xqnPg
Subscribe to YouTube & Follow on Dailymotion and Like Facebook Page👇
https://www.YouTube.com/exceluniverse
https://www.dailymotion.com/exceluniverse
https://www.facebook.com/exceluniverse.in
Download the Practice File here👇
https://mega.nz/file/tvow3A5J#clYg1OinoxIppyS6lyHhtELno0OuQfYX7c5f4wYpTvU
