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 […]
VBA/Macro
Excel Function
Date and Time, Function
Use of Eomonth Function In Excel
EOMONTH With the help of EOMONTH Function in excel, we determine the date of the last day of the
Uncategorized
Use of Edate Function In Excel
EDATE With the use of Excel EDATE function, we add or subtract month, with a date. We use EDATE
Basic, Text
Use 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
Basic, Text
Use 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
Basic, Text
Find 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.