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 👉 • Lookup and Reference Function in Excel
Indirect Number 👉 • Ms Excel INDIRECT Function || Power of Aut...
ISNUMBER Functions 👉 • IS Function-ISBLANK, ISERROR, ISERR, ISEVE...
Subscribe to YouTube & Follow on Dailymotion and Like Facebook Page👇
/ exceluniverse
https://www.dailymotion.com/exceluniv...
/ exceluniverse.in
Download the Practice File here👇
https://mega.nz/file/tvow3A5J#clYg1Oi...