Excel Tips

by admin on January 11, 2009

Remove Duplicated Content

I would like to share with you a excel tip that i have used.Let’s see the picture below.

The left side is original data and the rignt is what we want.This tip is remove duplicated content.

Just follow all the process below and you will know how to do this.

remove-duplication-original.jpg
Next Step
remove-duplication-step2.jpg
Next Step
remove-duplication-step3.jpg
Next Step
remove-duplication-step4.jpg
Next Step
remove-duplication-step5.jpg
Next Step
remove-duplication-step6.jpg
Thas’s all.Good luck

Text To Column

The excel tip below show you how to change text in a column into some columns.

The first picture below is what you want in this tip.ollowing other steps to learn this tutorial.

This guideine is very easy that you follow without problem.Any problem

Bookmark and Share:
Share This Post

Leave a Comment

CommentLuv Enabled

Previous post:

Next post: