is it possible to do lookup with cells containing tildes "~"?
Hi there,
I've been using vlookup on my tables and just discovered that the lookup
actually failed when the cell contains one or more tildes "~" (well never
really use a tilde for it's special purpose before).
Is there any way that Excel's lookup can match my titles with tildes as well
? if not then I guess I'll have to replace all my tildes in my cells to other
signs......probably hyphens.
Many Thanks in advance!
Steven Vegeta
|