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 moreWith Use of right function in MS Excel. We can extract some text from right side from a cell value. for Example:- If we have computer in A1 cell. With below formula we can extract 3 character from right side of call value Text Function
Read moreWith the help of Len & Substitute Function. We can found out how may words used in a Cell. Text Function
Read moreWith Use of left function in MS Excel. We can extract some text from left side from a cell value. for Example:- If we have computer in A1 cell. With below formula we can extract 3 character from left side of call value Text Function
Read more