Excel Currency Filtering

Copper Contributor

Hi all, 


I was wondering if anyone could help with a sorting problem I currently have.

I’ve got a spreadsheet in excel with a Column which includes USD & CAD. (Both shown in this format as opposed to $ etc) Is there a way I can filter the column via these currencies? I’ve attempted numerous methods but haven’t been able to make any progress. 

If anyone is able to help I’d greatly appreciate it ! 

Many Thanks

1 Reply


I fear you'll have to create a separate column that contains USD or CAD as text, and filter on that.