Searching problems with "~" (tilde) in cells

Why won't Excel recognise any entry in a cell that contains a ~. For example I have lists of job numbers such as FI9CMR~002 or RE1RE~~004.

The ~ is essential to us in order to pad out the number to 10 characters. This data is exported into excel from another database.

Advice or guidance appreciated.

Thanks