January 11, 2009
Excel Tips
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.
![]() |
| Next Step |
![]() |
| Next Step |
![]() |
| Next Step |
![]() |
| Next Step |
![]() |
| Next Step |
![]() |
|
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
![]() |
![]() |
![]() |
![]() |
![]() |
| Tha's all You can select the alternative way from step 1 as pictures below |
![]() |
![]() |
![]() |
| 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
![]() |
| You can use formula below: |
![]() |
Tags: hvac, drain pipes, pipe wrench, named pipe, pipe fittings

Filed under Other Collection by admin































































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