Wildcard With Vlookup
Dear All, From this video you can learn How to use vlookup wildcard. Download File for Vlookup with Wildcard
Read moreTag: Excel macro
Use of LCASE Function In Excel VBA Macro
LCASE 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 moreUse of Edate Function In Excel
EDATE 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 moreUse of Left Function in Excel VBA Macro
LEFT We can use left function in excel & macro both. With the help of left function we extract characters from left site of a cell value or string. हम Left Function का प्रयोग Excel & Macro दोनों में करते हैं. Left Function की मदद से हम किसी Cell की वैल्यू से Left side से characters निकाल सकते है. We have Computer value in Cell A1. We use Left(Range(“A1”).Value, 3) to pick 3 character from left side of A1 cell […]
Read moreFind Out How Many Words Used In A Cell
With the help of Len & Substitute Function. We can found out how may words used in a Cell. Text Function
Read more