Page 212 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Clean data
If some data entries in your worksheet begin with a leading space, Flash Fill can get rid of them in a blink. Type
the first value without a preceding space, and all extra spaces in other cells are gone too:

Formulas to clean data
• Excel TRIM function - formulas to remove excess spaces in Excel.

Data cleaning tools
• Trim Spaces - trim all leading, trailing and in-between spaces but a single space character between words.
Format text, numbers and dates
Quite often the data in your spread sheets is formatted in one way while you want it in another. Just start typing
the values exactly as you want them to appear, and Flash Fill will do the rest.
Perhaps you have a column of first and last names in lowercase. You wish the last and first names to be in proper
case, separated with a comma. A piece of cake for Flash Fill.

Maybe you are working with a column of numbers that need to be formatted as phone numbers. The task can be
accomplished by using a predefined Special format or creating a custom number format. Or you can do it an
easy way with Flash Fill.

To re-format the dates to your liking, you can apply the corresponding Date format or type a properly formatted
date into the first cell. Oops, no suggestions have appeared… What if we press the Flash Fill shortcut (Ctrl + E)
or click its button on the ribbon? Yep, it works beautifully!

199

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77