What exactly do VLOOKUP and MATCH do with tildas (~) in text strings?

=VLOOKUP("Hello~ World",array,2,0)
will match "Hello World" but not "Hello~ World"

=MATCH("Hello~ World",array,0)
will not match either string.

I am using Excel 2003, and Help does not say anything about this for either
function.

Jerry