October 10, 2014

There are hundreds of formulas in Excel. In this post I would like to cover some of the Text Functions in Excel. 


Assumption: A1 has a word Upskill Technologies


Len: Len returns the number of characters in a string.


Ex: =Len(A1)  would return 20


Left: Left returns n nu...

July 13, 2014

Application object contains application-wide settings and options. Below are few commondly used codes to control events using Application object.




Once the vba code copies a data and to remove the highlighted selection use the above command...

Please reload

Featured Posts

Excel Demo Video

November 14, 2014

Please reload

Recent Posts

November 14, 2014

Please reload

Search By Tags