I have a data set that has names that contain
~ within them. Unfortunately, I cannot find a way to filter or incorporate these cells in a formula.
For example, I tried to use a text cell that had
~ within the name, but I would receive a
#N/A error. I know that my VLOOKUP formula works because the only errors I receive are with cells that contain
~ within them.
I even attempted to filter out these results, but excel would replace the filter and treat it like a wildcard filter.
My questions are:
- How do I filter
- How do I use text cells that contain
~ in VLOOKUPS?