January 11, 2009

Excel Tips

Advertising


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  you can inform us by write comment
 

text-to-column-original.jpg
text-to-column-step1.jpg
text-to-column-step2.jpg
text-to-column-step3.jpg
text-to-column-step4.jpg
Tha's all
You can select the alternative way from step 1 as pictures below
text-to-column-step2a.jpg
text-to-column-step3a.jpg
text-to-column-step4a.jpg
Well done

Combine Column Excel Tip

This excel tip show you how to combine all column in to one column.

The first picture is what we want.The second one is…the formula

That's all

All you need to do is follow step by step.This tips is very helpful

Good luck and enjoy

combine-column-original.jpg
You can use formula below:
combine-column-step1.jpg

Tags: , , , ,

Share This Post

Filed under Other Collection by admin

Spread the Word!

Permalink Print Comment

Comments on Excel Tips »

January 11, 2009

Olivier @ 12:14 pm

There is a standard feature to achieve the remove duplicate content in Excell 2007(tip n°1)
=> Tabs "Data", "Remove duplicates" !

Leave a Comment

Register Login