Dear Friends,
I would like to develop a macro for the following data but not able to generate the code.I am providing the logical steps below.

Data Set in Column A
acdb-UL22A*
dabc-US25-1*
pirt-2-3p
ncb-N367
htr-H14-3p
trf-H7*
.
.
.
.
.
So on (This strings are in each cell accordingly in column A)

As "*" at the end is a wildcard character therefore counting this strings (How many are present (frequency) of each string type) is not possible.

So, the logical steps of the code will be as follows:
1.SELECT the cells containing strings in column A.
2.COPY the cells with the data content to Column B.(To protect the original data).
3.SORT them alphabetically
4.SUBSTITUTING "*" character with "~*" (So that "*" will not be considered as wildcard)
5.COUNTING/CALCULATING the frequency of each cell strings
6.RETURNING the values of the count and
7.SAVE the whole worksheet

Looking forward for your help.