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 from the text string. Syntax […]
Tag: excel tips
Top 5 Method To Convert Negative Number Into Positive Number
Have you ever need to convert Positive number from Negative in Excel ?? If there is one or Two Number need to convert then we manually write same number without negative sign. But When there is many cells have negative numbers and you have to convert it is Positive Number then Manual Work Will be […]
How to Open Excel With Specific No of Sheets
Microsoft Excel: (Hindi के लिए यहा क्लिक करे ।) Have you notice that your Excel Workbook is always open with 3 Sheets?? Some times you need to delete Extra Sheets from Excel Workbook.In some of Cases You Required more than 3 Sheets or any Specific no of Sheets for routine work.is there is any tactic […]
Top Excel Shortcut For Windows
Excel is one of the most usable to Office Product which is used worldwide. Here going to share Excel shortcut to use in day to day to work. File Menu Shortcut of excel: Create New Workbook – CTRL + N Open New Workbook – Ctrl + O Print File – Ctrl + P Open Print […]
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 is below given. Syntax : […]
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 have one simple trick which […]
How to Use Exact Function in Excel
Hi friends, In this article we learn use of Exact Function in Excel. in Excel Exact Function is used when we required to compare two text or any two cell values. Exact Function compare two values and if it is exactly Match its return with True otherwise it is returns False. Exact Function is case […]