THIS IS BASIC COADING FOR APPLY AUTOMATIC FILTER IN EXCEL SHEET
Advancefilter.applyfilter
AGAR KISI CELL ME TEXT AUR NUMBER EK SATH AUR ISE ALAG KARNA CHAHTE HE TO
THIS FORMULA APPPLY IS FORMULE SE NUMBER ALAG HO JAYEGA
=RIGHT(L823,LEN(L823)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},L823&"0123456789"))+1)
AND IS FORMULE SE TEXT ALAG HO JAYEGA
=LEFT(L824,MIN(FIND({0,1,2,3,4,5,6,7,8,9},L824&"0123456789"))-1)
No comments:
Post a Comment
THANKS FOR YOUR SUPPORT