Data Cleaning in Excel | Fix Blank Cells, Text Formulas & Select Visible Cells Only

hi i am manoj kumar join excel course https://excelguru.graphy.com/ In this Excel tutorial, I will show you how to clean raw data downloaded from SAP purchase details. Many times the data contains blank cells, text-formatted formulas, or other issues that make it difficult to work with. In this video, you will learn step by step how to fix these problems and prepare clean data for analysis. What you’ll learn in this video: How to use Ctrl + G (Go To Special) to select blank cells Fixing issues where blank cells don’t behave properly tally data download Using Text to Columns to solve blank cell problems Converting formulas stored as text back to normal formulas Changing cell format from text to general How to use Select Visible Cells Only effectively Perfect for anyone working with SAP exported purchase data or large Excel datasets that need cleaning. by @manojkumarexcel from bhorha simri bakhtiyarpur saharsa bihar india