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
|