Extract Last Name from Cell Value
Dear All, From this video you can learn how to extract last word from a Cell in Excel.
Read moreMonth: January 2018
Extract Last Name from A Cell Value
Dear All, From this video you can learn how to extract last word from a Cell in Excel.
Read moreUse of Len Function in Excel Vba Macro
LEN In excel vba we use LEN Function to count number of character is used in any supplied string and we store it at supplied variable. Excel vba में हम Len Function का प्रयोग किसी String या Cell में मौजूद value का length जानने के लिए करते है कि यहाँ कितने character use हुआ है और उसे हम एक variable पर store करते है. Example 1:- Sub LEN1() Dim LN As Integer LN = Len(“COMPUTER”) End Sub In […]
Read moreHow To Print In Excel-1
How To Print In Excel Dear All, From this video you can learn how to print in excel.
Read moreHow To Print In Excel
How To Print In Excel Dear All, From this video you can learn how to print in excel.
Read moreuse of MKDIR Function in Excel Vba
MKDIR In excel vba we use MKDIR vba function to create folder. MKDIR Function का उपयोग हम excel vba में folder बनाने के लिए करते है. I have to make a folder in D Drive which name will be computer. For this we have type code हमें D drive में एक फोल्डर बनाना है जिसका नाम COMPUTER होगा. इसके लिए हमें यह कोड लिखना होगा. Sub MakeFolder() MkDir “D:\COMPUTER” End Sub This Code will make folder in D Drive. यह […]
Read more