Hi All,

Im at a bit of a stump and really want to find an easy way of doing things

Basically I have text as follows

1012: Bobs Insurance
2067: Bobs insurance
3067: Travis Perkins
2222: Travis Perkins
1234: Travis Perkins

I have broken this down to just the name,

Bobs Insurance
Bobs insurance
Travis Perkins
Travis Perkins
Travis Perkins


but I need all names showing but they cant be duplicated.

I need it to look like this for example:

Bobs Insurance
Bobs insurance (1)
Travis Perkins
Travis Perkins (1)
Travis Perkins (2)

Is there any quick way of doing this, such as using the find/replace option as I have over 500 duplicate names

many thanks

really sorry for the poor description