MIS-Interview Series-Q8
MIS-Interview Series-Q5 Question was asked in MIS Interview. https://youtu.be/CiEq4Oi4HsI
Read moreTag: ucase function
MIS-Interview Series-Q7
MIS-Interview Series-Q5 Question was asked in MIS Interview. https://youtu.be/CiEq4Oi4HsI
Read moreGo to Linked cell In Excel Formula
In excel when we make formula with another cell, then we require to go that cell. एक्सेल में जब हम किसी और cell से formula बनाते हैं तो हमें उस cell में जाना पड़ता है. Then we use name box or Goto special methods. उस cell में जाने के लिए हमें Name Box या goto special method का उपयोग करतें हैं. With Name box:- We type computer in R100 Cell and in cell F4 typed =R100 then value from […]
Read moreConcatenate Multiple values in one cell
We have to Concatenate multiple cells value in one cell. हमें कई सारे cells का value एक cell Concatenate में करना है. There is some value in cell A1 to A6, we have to concatenate these value A1 to A6 into cell C3 with space यहाँ cell A1 से C6 में कुछ value है,हमें इन सारे values को C3 में space के साथ Concatenate करना है. Type =A1:A6&” […]
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