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 moreDear All, From this video you can learn how to extract last word from a Cell in Excel.
Read moreDear All, From this video you can learn how to extract last word from a Cell in Excel.
Read moreHow To Print In Excel Dear All, From this video you can learn how to print in excel.
Read moreMKDIR 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 moreUCASE We use UCASE function in excel macro. With use of Ucase function we convert a string into upper case. We have “computer” value in A1 cell, I want that “computer” word will be converted in upper case like “COMPUTER” and will be pasted in A5 cell. For this we have to use Range(“A5”).Value=UCase(Range(“A1”).VALUE) UCASE Function का प्रयोग हम Excel Macro में करते है. UCASE का प्रयोग कर हम किसी string के letter को Upper case में convert […]
Read moreDear All, From this video you can learn How to use vlookup wildcard. Download File for Vlookup with Wildcard
Read more