Excel AND & OR Function
Dear All, From this video you can learn use of AND & OR Function in MS Excel.
Read moreTag: vba macro function
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 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 moreUse of Right Function in Excel VBA Macro
RIGHT We can use RIGHT function in excel & macro both. With the help of right function we extract characters from right site of a cell value or string. हम Right Function का प्रयोग Excel & Macro दोनों में करते हैं. Right Function की मदद से हम किसी Cell की वैल्यू से Right side से characters निकाल सकते है. We have Computer value in Cell A1. We use Right(Range(“A1”).Value, 3) to pick 3 character from right side of A1 cell […]
Read more