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

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 ',' ?)

" wrote:

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

On Jan 29, 12:42*pm, Ron@Buy wrote:
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 ',' ?)

" wrote:
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

Yes, this is only an example.

The typical block of citations would have this format:

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

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

" wrote:

On Jan 29, 12:42 pm, Ron@Buy wrote:
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 ',' ?)

" wrote:
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

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

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

On Jan 30, 2:51*am, Ron@Buy wrote:
" wrote:
On Jan 29, 12:42 pm, Ron@Buy wrote:
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 ',' ?)

" wrote:
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

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