How to use LEFT Function with Find Function
LEFT Function with Find Function allows you to quickly extract number of characters in the given text string.
#Excel
189 postsLookup Multiple Fields of Data with Excel VLOOKUP
Sometime we need to lookup multiple fields of data with Excel VLOOKUP function. You can use Columns or Column or array with…
Autosave Excel file using code to protect file
Two ways to quickly Autosave Excel file to protect any crashes. Either you can use the code or turn on Autosave feature…
How to Group and Ungroup of Excel Pivot Table Data
Excel Pivot table allows you to manage and summarize excel worksheet data. You can group & ungroup pivot table data row or…
How to add suffix in range of cells in MS Excel
Sometime you need a quick way to add a prefix or suffix to all cells with in a range. Excel allows you…
How To Sum Cells With Text And Numbers appended in same cell in Excel?
Normally you can't do this job, but Sum array allows you to get the get the sum cells with text & numbers…
How to create and modify calculated fields in Pivot Table
Pivot table allows you to create, add calculated fields, apply formulas, & delete them. You can modify calculated fields in Pivot Table.
Important Text Functions of Microsoft Excel
Lot of text function in MS Excel. If you want to apply any formula on text that you have to use given…
How to split active worksheet in several pages in MS Excel
Trick to split active worksheet in several pages in MS Excel, in different pages to set or print header or footer area.
Insert a blank Row between existing each Rows of data in Excel
Sometime you need to add blank rows, Excel allows you to quickly and easily insert a blank row between existing each rows…