View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jake Jake is offline
external usenet poster
 
Posts: 83
Default Sorting different strings of text

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