C
Colin Foster
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
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