SOrting by currency symbol

Hi Richard, thanks for your query. Couple of thoughts, you could use a linked formula to trim off the $ symbol and then reformat those cells into currencies. Alternatively, use the $ sign as a delimiter, split the cells up to separate the values out and then reformat out. Basically, you need to get the raw data out of those cells with mixed text & numbers and then use data formatting before you filter. If you have large amounts of data consider building a macro as well.

Hope this helps,

Anthony