What does "~" do to the data in a cell?

  • Thread starter WarrenApplegate
  • Start date
W

WarrenApplegate

When doing a vlookup, I'm searching for the the name
"Allianz~" from the list against a set of data which contains this name. It
won't return any values. However, when I remove the "~" from data table, it
returns a value. Why does this happen, as I am searcing for a constant, and
it appears to be returning when the cells are different? Thanks.
 
L

Luke M

The ~ symbol normally is used to proceed wildcard characters to tell XL that
you are looking for a literal *, and not using wildcards. You may need to
search for "Allianz~~" in order to tell XL that you are actually looking for
a tilde.
 
W

WarrenApplegate

Excellent! Thanks

Luke M said:
The ~ symbol normally is used to proceed wildcard characters to tell XL that
you are looking for a literal *, and not using wildcards. You may need to
search for "Allianz~~" in order to tell XL that you are actually looking for
a tilde.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...
 
Top