Sorting a block of page number citations

  • Thread starter Thread starter alfred.cloutier
  • Start date Start date
A

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
 
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 ',' ?)
 
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 ',' ?)
Click to expand...

Yes, this is only an example.

The typical block of citations would have this format:

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

[from 1 to 4 numerals][COMMA][SPACE]
 
[email protected] said:
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 ',' ?)
Click to expand...

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:
Click to expand...
"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.

Yes, this is only an example.
Click to expand...
The typical block of citations would have this format:
Click to expand...
####, ####, ####, ####, ####
Click to expand...
[from 1 to 4 numerals][COMMA][SPACE]
Click to expand...
Try doing search in this community for:
Click to expand...

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