You could use TEXT TO COLUMNS to split out the strings
You may have to do a global search and replace for spaces
Sort the results (from left to right)
Concatenate them back together with =A1 & ", " & B1 ... etc
--
HTH,
Barb Reinhardt




"Jake" wrote:

I'm trying to sort a column of text separtated by commas, where the same
strings may not always be in the same order within the cells. I'm trying to
run a pivot off these codes, but I'll probably double the size of the chart
if I can't sort.
ie
pr905,m806,pr903,
pr905,pr903,m806,
pr903,pr902,
pr902,pr903,
M807,PR903,
PR903,M807,

I'd appreciate any help--
Thanks in advance,
Jake