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

Click on the Options button on the Find dialog (if you don't see the options)

Then change the Look in: option to Values

I'm guessing you have either Formulas or Comments in that option.


Colin Foster wrote:

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

--

Dave Peterson

Dave,

Thanks for this that sort of sorted it :-)

The Find now works in Excel, the problem is that's just an intermediate
stage & I'm then accessing the Excel database from another program & it was
that, initially, that couldn't find the value (which also, couldn't be found
through CTRL+F). So, the second part (CTRL+F) now works, I just need to sort
the other part

Regards
Colin

"Dave Peterson" wrote:

Click on the Options button on the Find dialog (if you don't see the options)

Then change the Look in: option to Values

I'm guessing you have either Formulas or Comments in that option.


Colin Foster wrote:

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

--

Dave Peterson