How to use LEFT Function in Excel

When to Use Left Function ? When you want to Extract Specific Number of Character from Cell or String from the First Character of Left Side. How to Use Left Function ? First of all you have to refer main text and number of character which you want to extract Read more…

How to use Rept Function in Excel

How to use Rept Function in Excel? Rept Function is used in excel to return a text or value repeatedly specified number of times. Some times we need to repeat some text or value multiple times in excel. Rept is inbuilt function of Excel. Syntax : Syntax of Rept Function Read more…

How to Type Same Data in Multiple Cell?

How to Type Same Data in Multiple Cell (Hindi के लिए  यहाँ क्लिक करे) Have you ever need to write same content in multiple cells in Microsoft Excel Workbook?It is very Time Consuming work and boaring work. Even copy paste same data in multiple cell also time consuming work. We Read more…