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 moreDear All, From this video you can learn How to use vlookup wildcard. Download File for Vlookup with Wildcard
Read moreLCASE We use LCASE function in excel macro. With use of lcase function we convert a string to lower case. We have COMPUTER value in A1 cell, I want that COMPUTER word will be converted in lower case like “computer” and will be pasted in A5 cell. For this we have to use Range(“A5”).Value=LCase(Range(“A1”).VALUE) LCASE Function का प्रयोग हमलोग Excel Macro में करते है. LCASE का प्रयोग कर हम किसी string के letter को Lower case में convert करते […]
Read moreDear All, From this video you can learn How to use vlookup wildcard. Download File for Vlookup with Wildcard
Read moreEOMONTH 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 moreEDATE With the use of Excel EDATE function, we add or subtract month, with a date. We use EDATE function to calculate Maturity Dates, Expiration Dates, Due Dates, Project Start Date, Project End Date. If we use month value as positive, then it will go future date, if we use month value as negative then it will go past date, if we use month value 0 then it will show same date. Here only month & year will be […]
Read more