I have a huge file with a lot of repeat text in the cells that i wish to clean up.

What is the procedure to do this? An example of my dilemma is attached.

Thanks,

Work Date Unit CMA Segment Child Activity
16-Oct-06 AMV505 CA14 14A855GG 1140
16-Oct-06 AMV505 CA14 14A855GG 1140
16-Oct-06 AMV505 CA14 14A855GG 1140
16-Oct-06 AMV505 CA14 14A855GG 1140
16-Oct-06 AMV505 CA14 14B3845A 1140
16-Oct-06 AMV595 CA14 14B3845A 1140
16-Oct-06 AMV617 CA14 14L637EE 1140
16-Oct-06 AMV617 CA14 14L637EE 1140
16-Oct-06 AMV617 CA14 14L637EE 1140
16-Oct-06 AMV505 CA14 14L834DD 1140

As you can see there is a lot of repeat text that I only want to see one of.

tlsomer