On 10 Aug, 01:39, Dallman Ross <dman@localhost. wrote:
In , Dave Peterson
spake thusly:

Check your other posts, too.

IOW: "It is possible that duplicates of this text may appear
in" other posts.

:-)

Tommy wrote:

I have two columns, A and B. Each column contains a list of
data in text format e.g. 01TI518A.PV . It is possible that
duplicates of this text may appear within either column. Also,
the number of data values in each column is variable as they
are imported from an external source into the worksheet. I
would like to be able to combine the text from both columns
into a single list in a single column, say column C. I would
also like this column to be alphanumerically sorted. How do I
go about doing this?

=dman=

many thanks for your help. i post so that i get an answer, spreading
my chances as it were. well done for pointing that out in your
pointless post.