If you have such type of MS-Excel file which data have so many Unwanted/ blank/extra space before and after text. That is also called leading, trailing and non-breaking spaces. Then in this video, you will know to remove extra whitespace from entire column at once.
If your excel cell is not scrolling, that means Scroll Lock is on. In this video, you will learn to remove/unlock/disable/turn off scroll lock in excel. So watch this video till the end for the Read more…
If you want your Excel data more accurate then you can create a Drop-Down List in Excel. (Using Data Validation). In this video, you will learn to make two types of drop-down lists in excel, Read more…
Flash Fill is one of the best tools of MS-Excel. It automatically fills your data when it senses a pattern. You just need to enter a sample text, you want as output. Flash Fill will Read more…
1 Comment
[VLOOKUP explained] VLOOKUP formula in Excel with example | VLOOKUP example between two sheets | Get eSolutions · April 12, 2020 at 7:15 am
[…] ➤ [Trim Function] How to remove extra spaces in MS-Excel | Remove blank spaces in excel ➤ [Datedif Excel] How to calculate date difference in Excel | Excel Date Difference (adsbygoogle = window.adsbygoogle || []).push({}); […]