Hi,
I have an excel spreadsheet that pulls sales order information (through MS
Query) from a client's accounting system. One of the cells then concatenates
two cells together to generate a unique value of the Customer Account Number
& Product Number

The formula used is, for example, =TRIM(A2&H2) & this is in AA2

I use the TRIM function to remove any extraneous data

So, in, AA2 is the value of HIL0015254 where HIL001 is the customer (in A2)
& 5254 the product code (in H2).

Now, if I do CTRL+F & search for HIL0015254, I receive an error message
sayng that the value can't be found.

Any suggestions?

Cheers
Colin Foster