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

Hi Princess,
One simple way is with a helper column.
If your data is in Column A, stating A2, then in B2 enter:
=RIGHT(A2,1)
Copy down to the last row of your data in Column A.
Select all data in Columns A and B:
Data Sort:
Sort By: Column B.
OK

Regards - Dave.

"Princess Caroline" wrote:

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