How To Clean Data In Excel Spreadsheet?
As most of the user, uses Excel spreadsheet but sometimes the user’s wants to clean the
data in Excel. So, in this blog you will read how to clean data in Excel. For more
information about Excel, just click on www.office.com/setup.
Method To Clean Data in Excel Spreasheet:
1: Clear Duplicate Data In Excel:
For this, first you have to tap in the Excel Spreadsheet. After this, you need to tap on
Table Tools. Then, you have to click on Design. At this point, you should click on
Remove Duplicate. At last, you should select the column which has duplicate data and
then tap on OK button.
2. Text To Column Feature:
You should select the text which you wish to split into multiple cells. Then, you should
tap on the Data tab. Now in Data Tools, you should select Text to Columns. Here in
Convert Text to Columns Wizard, you should select the Delimiters checkbox. At this
point, you should tap on the Next button. Then, just under Delimiter, you should select
the Space checkbox and just leave the rest of the checkboxes. At last, tap on the Finish
3. Convert Numbers:
First, you need to type 1 in any blank cell. After this, where you have typed 1, just select
that cell and tap on Ctrl + C together. Now, you have to select the cells which you want
to convert into numbers. Then, you need to right-click and then select Paste option. After
this, you need to select Paste Special in order to open the Paste Special Dialogue box.
Here, in the operation section, you should select Multiply and tap on Ok button. For more
info, click on office.com/setup.
4. Remove Blank Cells:
If you have a huge Excel file, then you should select blank cells at a time. For this, you
should select the data set in Excel. Then, Go To dialogue box, and press F5 key. Now,
you should Go To Special dialogue box, and then select the Special option. Here in Go
To Special, you should select Blanks and then tap on OK button.
5. Find And Replace Feature:
To replace data in Excel Spreadsheet,