Remove duplication and sort a string

This is my first time coding in VB. I'm using excel 2007 and windows vista.

I have 2 cells, A1 contains (01,) and B1 contains (01, 08). I want the result in cell C1 to be (01, 08) by calling function trim_sort($A1&$B1)

The code gives me an error "invalid qualifier" for s.length & more

Could you please have a look at my code, and tell me what's wrong.

Please Login or Register  to view this content.

Tim,

Welcome to the forum.

In order to avoid having to answer the same questions every day, we require that posters compose thread titles that make the forum usefully searchable. Your title doesn't advance that goal.

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.

In addition, please change the quote tags to Code Tags.

Try this:

Please Login or Register  to view this content.

For example, =StrSort2("06, 01, 08, 01", TRUE) returns "01,06,08"