Excel Daily Use Formulas.

1. Extract Number from Sentence in Excel.
=SUMPRODUCT(MID(0&A2,LARGE(INDEX(ISNUMBER(--MID(A2,ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)
or
=RIGHT(A2,SUM(LEN(A2) - LEN(SUBSTITUTE(A2, {"0","1","2","3","4","5","6","7","8","9"},""))))

2. I use a helper column in which I concatenate the number with a letter to make it an alphanumeric entry.
=concatenate("a",'large number cell') or ="a"&'large number cell'
a26200008004000800000000000000001

3. Countif Using Vlookup
=COUNTIF('Download Till Date Visits '!A2:$A$41908,VLOOKUP(Sheet1!B2,'Download Till Date Visits '!$A$2:$A$41908,1,0))

4. How to find Last Digit in Excel
=IF(F2>=1,$F$1,IF(E2>=1,$E$1,IF(D2>=1,$D$1,IF(C2>=1,$C$1,(IF(B2>=1,$B$1,IF(G2>=1,$G$1,FALSE)))))))

5. =DAY(DATE(YEAR(A2),MONTH(A2)+1,0))

6. Latest Entry in Google Form.
=MAXIFS('Form Responses 1'!A:A,'Form Responses 1'!C:C,D2,'Form Responses 1'!D:D,C2)
==MAXIFS'TimeStamp,'ULB Names,ULB Name,'Phases,Phase)

7. Sum using Specific Criteria
=SUMIF(range, criteria, (sum_range))
=SUMIF($D$2:$D$41,G2,$E$2:$E$41)

8. Split after specific chrater and put the value.
=LEFT(L2,FIND("/",L2)-1)
=Right(L2,FIND("/",L2)-1)

9. Copy Only Value for Addition if the value with formula not working.
=VALUE(M2)

10 Sum with #N/A
=sumif(A1:D1,"<>#n/a")

11.Sum with #N/A but sum different-different shell
=IFERROR(A3,0)+IFERROR(A11,0)

12. use to get numbers between alphabets.
=SPLIT( LOWER(A2) ; "abcdefghijklmnopqrstuvwxyz " )

13. remove specific symbol in excel.
=RIGHT(A1,LEN(A1)-FIND(",",A1))
=LEFT(A1,FIND(",",A1)-1)

14.how to remove any unwanted characters (symbols, alphabet, number) from the text in excel
=CODE(J2) to get the code of any character
=SUBSTITUTE(M2,CHAR(33),"") to remove that unwanted code

15. Fined latest visit or latest entry.
=IF(F2<>"",$F$1,IF(E2<>"",$E$1,IF(D2<>"",$D$1,IF(C2<>"",$C$1,IF(B2<>"",$B$1,"nd")))))