View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Princess Caroline Princess Caroline is offline
external usenet poster
 
Posts: 2
Default Separating characters from a cell so I can sort on them

I've got data that includes a variable. Either -B or -P. I need to sort on
this variable.
348.00-P
113.20-P
2023.90-B
411.00-B
504.00-B
135.00-P

Simple explaination, please. I don't really speak Excel language very well...
Thanks