Data Cleaning

--------- , R and SQL are used for large data

One of the easiest ways of cleaning data in Excel is to --------------- duplicates

Extra spaces are painfully difficult to spot. While you may somehow spot the extra spaces between words or numbers, trailing spaces are not even visible. There is a neat way to get rid of these extra spaces – Use ----------- Function.

When you get data from a database or import it from a text file, it may happen that all the text is cramped in one cell. You can parse this text into multiple cells by using Text to Column functionality in -------------- tab.

• Home

• Format

• Data

• View

To Convert Numbers Stored as Text into Numbers , we use ----------- function

• value

• Val

• Text

• txt

Finding "r" is the same like finding "R" using -------------- function

• Find

• Replace

• Search

Finding "r" is NOT the same like finding "R" using -------------- function

• Find

• Replace

• Search

The ----------------- function in Excel is used to combine the text from different cells into one 

------------------ converts any uppercase letters to lowercase.

---------------- function converts the first letter in each word to uppercase if it's lowercase and converts any other uppercase letters to lowercase