Four Common Ways to Clean Data in Excel

Merge/Split – Sometimes you have to either merge cells together or split them into multiple cells. For example, in Google Fusion Tables, the whole address (street, city, state, zip) must be in one cell.

Trim – This forumula will remove extra spaces from cells. You don’t want to delete them all one at a time!

Change case – Sometimes data comes in ALL CAPS. You can change it so it is more usable and readable.

Copy – You can copy and paste either contents, values or formulas by using “Paste Special” option.

This entry was posted in Excel Tips, How To. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s