Sorting a block of page number citations

[alfred.cloutier]

Not sure in what forum this problem should reside, but I've had luck
here.

I need to sort and delete dupes in a list of page number citations,
all existing in one cell:

1, 1, 3, 5, 7, 9, 2, 2, 4, 6, 8

Needs to appear as

1, 2, 3, 4, 5, 6, 7, 8

In one cell

Please advise if this would be better accomplished in Word, or VB.

Thanks!

Al

 

[Ron@Buy]

Apart from missing the 9 (?) you seem to have acomplished what you require in
this posting !!
Perhaps the numbers you list are for example only?
For anybody to give you a definitive solution we need a truer representation
of the numbers you are dealing with. (e.g. are they all single digit numbers
and always seperated with a ',' ?)

 

[alfred.cloutier]

Apart from missing the 9 (?) you seem to have acomplished what you require in
this posting !!
Perhaps the numbers you list are for example only?
For anybody to give you a definitive solution we need a truer representation
of the numbers you are dealing with. (e.g. are they all single digit numbers
and always seperated with a ',' ?)

Yes, this is only an example.

The typical block of citations would have this format:

####, ####, ####, ####, ####

[from 1 to 4 numerals][COMMA][SPACE]

 

[Ron@Buy]

Apart from missing the 9 (?) you seem to have acomplished what you require in
this posting !!
Perhaps the numbers you list are for example only?
For anybody to give you a definitive solution we need a truer representation
of the numbers you are dealing with. (e.g. are they all single digit numbers
and always seperated with a ',' ?)

Yes, this is only an example.

The typical block of citations would have this format:

####, ####, ####, ####, ####

[from 1 to 4 numerals][COMMA][SPACE]

Try doing search in this community for:

"Extracting multiple entries in a cell"
Herbert Seidenberg & Ron Rosenfeld offered possible solutions to your
problem on 6/19/2006

 

[alfred.cloutier]

Thanks! That appears to be along the lines of what I was looking for.

Yes, this is only an example.

The typical block of citations would have this format:

####, ####, ####, ####, ####

[from 1 to 4 numerals][COMMA][SPACE]

Try doing search in this community for:

"Extracting multiple entries in a cell"
Herbert Seidenberg & Ron Rosenfeld offered possible solutions to your
problem on 6/19/2006