Can you create a calculated field that concatenates C1, C2 and C3 together into a single field? Then put the filter on that?
Hi, i tried this formula [C1]+" "+[C2] +" "+[C3], but i got this (1 2 A).
And i just want to join C2 to C1. I wrote bad my question, sorry.
This should be the result that i want
C1 + C2
Sorry, I don't understand. You got it working to combine all 3? The formula for that looks ok.
If you just want C1 + C2 it's the same formula, just without C3.
If you can attach a workbook or some data, I'm happy to help further. Not clear what your question is since it looks like you got the formula working.