|Not sure what it is your doing, but here are two ways to get unique values.|
First and simplest:
Select your column that contains the text strings
Select the Data Tab on the ribbon
Select Remove Duplicates
You should be left with a column of Unique values.
Second way, that uses a formula:
Make sure your text column has a Label,
so your data looks like:
1) Text Label
2) First Line of Text goes here
3) Second Line of Text goes here
In Cell B2 enter the formula:
Without knowing how many rows you have,
you will need to modify range in the formula.
Drag down as many rows as needed.
You will now have all the Unique text strings in column B
Unsure if you plan on appending a number to the strings
or use an adjacent cell to number them.
But this should get you started.
message edited by mmcconaghy