Forum Discussion
Excel Currency Filtering
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
I fear you'll have to create a separate column that contains USD or CAD as text, and filter on that.
