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 moreTag: Excel Class
Use 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 moreUse of UCASE Function In Excel VBA Macro
UCASE 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 moreWildcard With Vlookup
Dear All, From this video you can learn How to use vlookup wildcard. Download File for Vlookup with Wildcard
Read moreUse of Eomonth Function In Excel
EOMONTH With the help of EOMONTH Function in excel, we determine the date of the last day of the month. It can be future or past date. We have to specify number of months before or after for this date. If use use eomonth(date,0), then it will return last day of date, which has given by us. If we use eomonth(date,2), positive number as month then it will go 2 months ahead and will return last date of that […]
Read more