View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
goonie goonie is offline
external usenet poster
 
Posts: 8
Default Sort / Filter in excel

I have a row of data that has strings of numbers / characters. Is there a way
to sort of the charaters whether they are at the beginning or end?

Example:
P224
24P
26A
28376A
A20958

I would like to sort by the Charater - when it either at the begining of the
string or end.

Thanks,
Kelly